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-11-15 : 10:03:28
|
| Harald writes "HiWe have got an application, where the user can send a SQL Query. But then it's possible that he receive 100'000 records or more. What we want to do, is to restrict the received records to 1000 (select top 1000 ...). But then, the user should have the possibility to click on a Next button and receive the next 1000 records and so on.What is the best way to do that? Performance is very important!Regards Harald" |
|
|
|
|
|
Get a specific amount of records.