本文介绍了一种使用SQL Server 2005实现高效分页查询的方法。通过ROW_NUMBER()窗口函数配合TOP子句，实现了指定页数及每页记录数的灵活分页。示例代码清晰展示了如何设置参数并选取特定范围的数据。
sql 2005+中的分页实现
Declare @rowsPerPage int
Declare @pageNum int
SET @rowsPerPage = 10
SET @pageNum = 1
With SQLPaging As (
Select Top(@rowsPerPage * @pageNum) ROW_NUMBER() OVER (ORDER BY ORDERID) as resultNum, ORDERID,OPERATOR,REASON FROM Ord_ProcessLog
)
select * from SQLPaging where resultNum > ((@pageNum - 1) * @rowsPerPage);
Declare @rowsPerPage int
Declare @pageNum int
SET @rowsPerPage = 10
SET @pageNum = 1
With SQLPaging As (
Select Top(@rowsPerPage * @pageNum) ROW_NUMBER() OVER (ORDER BY ORDERID) as resultNum, ORDERID,OPERATOR,REASON FROM Ord_ProcessLog
)
select * from SQLPaging where resultNum > ((@pageNum - 1) * @rowsPerPage);
扫一扫
144
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
