代码如下:
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 '
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 '