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 |
|
mailtoaloysius@gmail.com
Starting Member
1 Post |
 Posted - 2008-09-24 : 02:04:09
|
| Hi,Can we split and fetch query result in SQL server 2000.For example, in our inventory browser page, based on user input conditions the system need to pull set of records (say 1 million records) from the database. However not all records are displayed for the user in one short. The inventory browser page is designed to display only the first 100 records, on users subsequent request the next 100 records need to be fetched and displayed.How can we split (1 million records) and fetch (only 100 records at a time) the query results.Is there a concept like row number or a equivalent exist in sql server 2000Please provide some approach/suggestion |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-24 : 02:05:51
|
| Search for pagination in these forums.you will get lots of methods. |
 |
|
|
|
|
|
Can we split and fetch records in SQL Server 2000