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 |
|
huckfinn
Starting Member
1 Post |
 Posted - 2005-01-18 : 13:06:56
|
| Hi!I am writing an application in C#, using SQL Server, that needs to do a query on a huge table. I can get up to a million entries. I am looking for a solution that does the following:1- SELECT the rows that can fit in my current application page plus a couple more. Let's say, 50 items.2- When the user scrolls down the page, when I get to the event meaning that I need more results, I get the 50 next, and so on.I know that there is no "rowid" in SQL server, which would have been very helpful. I also know that I can use an offset, meaning that I would select the 50 first. Then the 100 hundred first to show the 50 next and so on. Can anybody help me with a clean solution to this? Does SQL Server offer any facilities to do this?I am using SQL Server 2000, developper edition.Thanks!Huck |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Virtual browsing with large SQL queries?