Shulou(Shulou.com)05/31 Report--

How to realize data paging in Sql Server? in view of this problem, this article introduces the corresponding analysis and solution in detail, hoping to help more partners who want to solve this problem to find a more simple and easy way.

Method 1:

DECLARE @ rowsPerPage int

@ pageNum int

@ startRow int

@ endRow int

SET @ rowsPerPage = 10

SET @ pageNum = 3

SET @ startRow = ((@ pageNum- 1) * @ rowsPerPage) + 1

SET @ endRow = @ startRow + @ rowsPerPage-1

SELECT * FROM (

SELECT row_number () OVER (ORDER BY id) as resultNum

Id FROM myTable

) as numberResults

WHERE resultNum BETWEEN @ startRow AND @ endRow

Method 2 (recommended):

SET @ rowsPerPage = 10

SET @ pageNum = 3

With SQLPaging

As

(

Select Top (@ rowsPerPage * @ pageNum) ROW_NUMBER () OVER (ORDER BY id) as resultNum, id

FROM myTable

)

Select * from SQLPaging where resultNum > (@ pageNum-1) * @ rowsPerPage)

This is the answer to the question about how to realize data paging in Sql Server. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.