sql-表值函数tvf

带有参数的视图

  create function fn_fenye
  (@count as int,@page as int) returns table
  as
  return
  select * from (select row_number() over (order by id)as num,* from dbo.Scores) as tableA
  where tableA.num between @count*(@page-1)+1 and @count*@page
 
  select * from fn_fenye(3,2)

　　

转载于:https://www.cnblogs.com/mongo/p/4434834.html