SQL Server 使用ROW_NUMBER实现的高效分页排序

declare @pageNum int
set @pageNum=1
declare @pageSize int
set @pageSize=10
select * from (select ROW_NUMBER() over(order by a_CreationTime desc) as rowNum,* from td_Articles) as c 
where rowNum between((@pageNum-1) * @pageSize+1) and @pageNum * @pageSize

 

参考：http://www.cnblogs.com/seusoftware/p/3272632.html