sqlserver Row_Number分页

最新推荐文章于 2025-03-01 00:36:07 发布

diwang0780

最新推荐文章于 2025-03-01 00:36:07 发布

阅读量287

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/yerenno1/articles/2036227.html

版权

本文详细介绍了一种使用SQL的ROW_NUMBER()函数进行分页查询的优化方法，通过创建存储过程实现动态排序和分页，提高了数据库查询效率。具体包括如何使用ROW_NUMBER()函数为记录编号，以及如何通过参数化存储过程实现灵活的分页和排序。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

代码如下：

1 select * from [ user ]
2
3 select *
4 from ( select ROW_NUMBER() OVER ( order by name) as fuck, * from [ user ] ) as yyyy
5 where fuck between 11 and 20
6
7 select *
8 from ( select ROW_NUMBER() OVER ( order by name) as fuck, * from [ user ] ) as yyyy
9 where fuck between 1 and 10
10 go
11
12 create proc Usp_User_Paging
13 @beginNo int ,
14 @endNo int ,
15 @colName varchar ( 50 )
16 as
17 begin
18 select *
19 from ( select ROW_NUMBER() OVER ( order by @colName ) as fuck, * from [ user ] ) as newTable
20 where fuck between @beginNo and @endNo
21 end
22 go
23
24 Usp_User_Paging 11 , 20 , ' name '

转载于:https://www.cnblogs.com/yerenno1/articles/2036227.html