SQL2005 Row_numer Two common ways to implement pagination _mssql2005

Copy Code code as follows:

DECLARE @PageNumber int
DECLARE @PageSize int

Set @PageNumber =2
Set @PageSize =20

--Using between

SELECT *
From
(
Select
Row_number () over (Source_ip,id) as Row_num,
* from TB) as Page_table
where row_num between (@PageNumber-1) * @PageSize + 1 and @PageNumber * @PageSize

--Using Top method

Select Top 20 *
From
(
Select
Row_number () over (Source_ip,id) as Row_num,
* FROM TB
) as Page_table
where Row_num > (@PageNumber-1) * @PageSize
ORDER BY Row_num
[/code]