sqlserver Row_Number分页
代码如下：
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'
