| 范文 |
sqlserver使用窗口函数实现分页
alter proc [dbo].[usp_getstupage]
@pageindex int =1,--当前页码
@pagesize int =10,--页容量
@pagecount int output--输出总页数
as
begin
select @pagecount=ceiling((count(id)*1.0)/@pagesize) from studentsinfo
select * from (
select *,row_number() over(order by id) as rownum from studentsinfo
)as t where t.rownum between (@pageindex-1)*@pagesize+1 and @pageindex*@pagesize
end |