Use SQL statements for paging

Declare @ pagesize int -- number of records displayed on each page
Declare @ pages int -- number of pages to be displayed
Set @ pagesize = 5
Set @ pages = 2
Declare @ SQL nvarchar (200)
Set @ SQL = 'select top '+ STR (@ pagesize) +' * from (select top '+ STR (@ pagesize * @ pages)
+ '* From blog_config order by blogid ASC) as t order by blogid DESC'
Exec (@ SQL)

/*
Paging using SQL statements
The first step to use this technology is to multiply the number of pages required by the page size, sort the results in ascending order using the top keyword, and then embed this query into another query.
This query is the number of records that take the page size. Is a descending Processing
This query returns the last page of the embedded query. If necessary, the final query results can be processed in ascending order.
*/