分页 存储过程 sql语句

//select * from (Select ROW_NUMBER() over(order by PAddTime desc) as num,*from Person) as t
//where num between 1 and 5
//order by PAddTime desc

//select * from (Select ROW_NUMBER() over(order by PAddTime desc) as num,*from Person) as t
//where num between 6  and 10
//order by PAddTime desc

 //select ceiling(7/6.0)

if Exists(select * from sys.objects where name='usp_Fye')
drop proc usp_Fye
go
create proc usp_Fye
@pagSize int,--每一个页面显示几条数据
@PagIndex int,--当前页码
@count int output
as
select * from (Select ROW_NUMBER() over(order by PAddTime desc) as num,*from Person) as t
where num between (@pagSize*(@PagIndex-1)+1)  and @pagSize*@PagIndex
order by PAddTime desc
 
 select @count=ceiling(COUNT(*)/CONVERT(float,@pagSize)) from Person
 
 declare @count int
 exec usp_Fye 5,4,@count output
 print @count