UPDATE ListVolume
      SET PAGE = CASE
                   WHEN ID_LISTVOLUME = @ID_IN THEN @SPage
                   ELSE PAGE - 1
                 END
      FROM (SELECT LV.ID_LISTVOLUME FROM ListVolume LV
            WHERE REF_REV = @LIMIT
              AND ISNULL(Ref_ListVolume, -1) = -1
              AND PAGE BETWEEN @SPage AND @EPage
            ORDER BY PAGE DESC) AS lv
      WHERE lv.ID_LISTVOLUME = ListVolume.ID_LISTVOLUME

ALTER TABLE foo NOCHECK CONSTRAINT CK_foo_column
ALTER TABLE foo CHECK CONSTRAINT FK_something

Declare @PageNumber int = 3, @PageSize int = 2
declare @Table as table (Id int primary key)
insert into @Table (Id) select 1 as id union all select 2 union all select 3 union all select 4 union all select 5

declare @Offset int
set @Offset = (@PageNumber - 1) * @PageSize + 1

--ROW_NUMBER with CTE and JOIN
with T as 
(select Id, row_number() over (order by Id desc) as row_number
		from @Table)
select T1.* 
	from T join @Table T1 on T.Id = T1.Id
	where row_number between @Offset and @Offset + @PageSize - 1;

DECLARE @StartingRowNumber tinyint = 1
      , @FetchRows tinyint = 8;
SELECT DepartmentID, Name, GroupName
FROM HumanResources.Department
ORDER BY DepartmentID ASC 
    OFFSET @StartingRowNumber ROWS 
    FETCH NEXT @FetchRows ROWS ONLY;