SQL创建分页
create procedure SP_PageIndex
(@pageIndex int,
@ItemsCountInEachPage int,
@pageCount int out
)
as
begin
with temp as (
select row_number() over(order by Test_orderColumn) as rowIndex, * from Test
)
select * from temp
where rowindex between @ItemsCountInEachPage*(@pageIndex-1)+1 and @ItemsCountInEachPage*@pageIndex
union all
select count(*), null, null, null as AllCount from temp
end