带有参数的视图
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)
原文：http://www.cnblogs.com/mongo/p/4434834.html