实现代码如下：
select * from
(
select *,row_number() over(order by OrderColumn) as orderindex from TableName
) as a
where a.orderindex between @StartIndex and @EndIndex
以上就是【SQL2005 大数据量检索的分页】的全部内容了,欢迎留言评论进行交流!
select * from
(
select *,row_number() over(order by OrderColumn) as orderindex from TableName
) as a
where a.orderindex between @StartIndex and @EndIndex