Recently in the ASP version and .NET section, there is a debate and introduction to database paging:
ASP version:
Http://community.9cbs.net/expert/topic/3369/3369310.xml?temp=.9789392
.NET section:
http://community.9cbs.net/expert/topic/3292/3292678.xml?temp =.8206293
Some people also spell the paging scheme, see:
SPL Server stored procedure paging scheme competition
Http://blog.9cbs.net/lihonggen0/archive/2004/09/14/103511.aspx
I have always used the first solution.
Some people in the first program have also made a detailed general stored procedure, see:
http://blog.9cbs.net/sun_jianhua/archive/2004/07/04/33574.aspx
with
http://blog.9cbs.net/pbsql/archive/2004/11/30/199657.aspx
It is necessary to pay attention to the establishment of primary keys and indexes. There is no other thing in the pagination :)
