Posted by Erland Sommarskog on 07/12/06 21:54

Robert P (rphilipson@legaleze.com) writes:
> I have a database with 10,000 records and I want to just see record
> 1000 - 1025 is there an easy way to do this with a query. I have found
> info for my SQL using limits but it does not work with SQL Server 2000.

Assuming that you want to do paging for display on a web page,
see SQL Server MVP's Aaron Bertrand article on the topic on
http://www.aspfaq.com/show.asp?id=2120.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]