For tables with primary keys in SQLServer, the write efficiency is high and the SQL query on the second page is displayed.

Declare @ pageSizeint -- return the number of records for one night declare @ CurPageint -- page number (page number) declare @ Countintdeclare @ idintset @ pageSize10set @ CurPage1 -- locate if @ CurPage-1begin -- setrowcount @ pageSizeselect @ idnewsIDfromnewsT

Declare @ pageSize int -- return the number of records for one night declare @ CurPage int -- page number (page number) declare @ Count int declare @ id int set @ pageSize = 10 set @ CurPage = 1 -- locate if @ CurPage =-1 begin -- set rowcount @ pageSize select @ id = newsID on the last page from newsT

Declare @ pageSize int -- returns the number of records for one night

Declare @ CurPage int -- page number (page number)

Declare @ Count int

Declare @ id int

Set @ pageSize = 10
Set @ CurPage = 1

-- Positioning
If @ CurPage =-1
Begin
-- Last page
Set rowcount @ pageSize
Select @ id = newsID from newsTemp order by newsID
End

If @ CurPage> 0
Begin
Set @ Count = @ pageSize * (@ CurPage-1) + 1
Set rowcount @ Count
Select @ id = newsID from newsTemp order by newsID desc
End

-- Return record
Set rowcount @ pageSize
Select * from newsTemp where newsID <= @ id order by newsID desc

Set rowcount 0