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