SqlServer利用Row Number() Over()与Between and 写分页存储过程

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