SQL 分页

分页

select * from

　　(select *, Row_NUMBER() over(order by 列名) as num from 表) as t

where num between 1 and 5

order by time desc

存储过程

create proc usp_GetPage

　　@pageIndex int,　　　　　　--页码

　　@pageSize int,　　　　　　　--页容量　

　　@pageCount int output        --共多少页

as

　　declare @n int

　　select @n=COUNT(*) from 表

　　set @pageCount =ceiling(@n*1.0/@pageSize )

select * from 

　　(select *, ROW_NUMbER() over(order by 列名)as num from 表) as t

where num between(@pageIndex -1)*@pageCount +1 and @pageIndex *@pageSize 

order by 列