Paste some code (1)

/******** A sqlserver pageCode*************/

Select top 10 *
From
(
Select [ID], [bigid], [smallid],
[Goodsname], row_number () over (order by id asc) as rowno/** select dozens of records in ascending order of IDs ***/
From [tb_goods]
) As
Where rowno> N * 10 // n indicates the number of pages to be displayed, and 10 rows of records are displayed on each page;

/***

This method has almost no restrictions, because it generates a new sorting column for any search. We can use this column for custom paging.

 

***/