If you are using SQL Server 2000, you have a number of options which are explained here:
http://databases.aspfaq.com/database/how-do-i-page-through-a-recordset.html. The article looks at paging records in classic ASP. so the first half of the article is irrelevant, but further down, there are a number of stored procedure options that work.
Aaron Bertrand found the last Stored Procedure options - the one that uses ROWCOUNT to be the best performer. Don't just grab the first one in the list.
Mikesdotnett...
All-Star
154818 Points
19853 Posts
Moderator
MVP
Re: select rows between 15 to 30 from sql server
Jul 28, 2010 06:53 AM|LINK
If you are using SQL Server 2000, you have a number of options which are explained here: http://databases.aspfaq.com/database/how-do-i-page-through-a-recordset.html. The article looks at paging records in classic ASP. so the first half of the article is irrelevant, but further down, there are a number of stored procedure options that work. Aaron Bertrand found the last Stored Procedure options - the one that uses ROWCOUNT to be the best performer. Don't just grab the first one in the list.
Beginning ASP.NET Web Pages with WebMatrix | My Site | Twitter