SQL2005 大数据量检索的分页

复制代码 代码如下:

select * from
(
select *,row_number() over(order by OrderColumn) as orderindex from TableName
) as a
where a.orderindex between @StartIndex and @EndIndex