create function udf_GetPagedView(
  @colname sysname, 
  @offset int,
  @length int
) returns table as 
return select * from sys.objects
 order by case
  when @colname = 'object_id' then object_id
  when @colname = 'name' then name
  -- тут еще другие могут быть столбцы
 end
 offset @offset rows fetch next @length rows only
go

create function udf_GetPagedViewWithNum(
  @colname sysname, 
  @offset int,
  @length int
) returns table as 
return
 select * from
 (select row_number() over(
    order by case
      when @colname = 'object_id' then object_id
      when @colname = 'name' then name
      -- тут тоже могут быть другие столбцы
    end) RowNum, * from sys.objects) t
  where @offset < RowNum and RowNum <= @offset + @length
go