SQL Server分页存储过程

go
create proc fenye_Pro
(
@pageIndex int,
@pageCount int
)
as
begin
select top(@pageCount)* from (select *,ROW_NUMBER() over(order by RowId) RowIndex from Task where条件) t where RowIndex > @pageCount*(@pageIndex-1)
end

posted @ 2021-02-24 15:17  小小白编程  阅读(34)  评论(0编辑  收藏  举报