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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 How to return rows 100 to 199

Author  Topic 

frozenBrains
Starting Member

1 Post

Posted - 2005-02-11 : 10:55:42
Hi

Does anyone know the sql statement to return a certain set of rows? Say my query returns 8000 rows and I want to display the data in block of 100s. Is there a sql statement to do this or do I have to gab everything?

Thanks!

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2005-02-11 : 11:20:49
do an article search for "paging"
also do a forum search for "paging"

There's lots of stuff on this topic

Be One with the Optimizer
TG
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2005-02-11 : 11:29:12
There's always Jeff's blog

http://weblogs.sqlteam.com/jeffs/archive/2004/03/22/1085.aspx



Brett

8-)
Go to Top of Page
   

- Advertisement -