How to realize data pagination in Sql Server
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.
