Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-25 : 12:06:26
|
Geoff writes "This is something of a followup to the recent question about numbering records.
Let's say you have a table with 70,000 records that users want to browse. The ASP page they are using to browse will display one "page" of 20 records at a time. One solution is to use the PageCount, PageSize, etc. properties of the ADO Recordset, but that means you are populating a Recordset object with 70,000 records before you can even start to page.
My question is: Can you implement this sort of paging entirely within Transact-SQL?" |
|
|
|
|
|
Paging with Transact-SQL