sqlserver分页的两种写法分别介绍

[c-sharp] view plaincopyprint?create proc p_paged1
@pageSize int,@currentPage int
as
select (@pageSize) from student
where id not in
(select (@pageSize(@currentPage-1)) id from student)
go
exec p_paged1 2,3
create proc p_paged1
@pageSize int,@currentPage int
as
select (@pageSize) from student
where id not in
(select (@pageSize(@currentPage-1)) id from student)
go
exec p_paged1 2,3

[c-sharp] view plaincopyprint?create proc p_paged2
@pageStart int, @pageEnd int
as
select from
(select ,row_number() over(order by id desc) as rnum
from student) t
where t.rnum between @pageStart and @pageEnd
go

exec p_paged2 5,10