How to realize pagination in sqlserver

How to achieve paging in sqlserver, I believe that many inexperienced people do not know what to do, so this paper summarizes the causes of the problem and solutions, through this article I hope you can solve this problem.

The first is the most traditional way of writing. Copy the code using the variables in the stored procedure as the paging multiplier: [c-sharp] view plaincopyprint?create proc p_paged1 @ pageSize int,@currentPage int as select top (@ pageSize) * from student where id not in (select top (@ pageSize* (@ currentPage-1)) id from student) go exec p_paged1 2 @ 3 create proc p_paged1 @ pageSize int @ currentPage int as select top (@ pageSize) * from student where id not in (select top (@ pageSize* (@ currentPage-1)) id from student) go exec p_paged1 2

The code for copying the paging statement after SQL Server2005 is as follows: [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 510

After reading the above, have you mastered how to achieve paging in sqlserver? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!