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, --页容量
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 列