Can you provide information about how to page results in SQL Server pre-2005?
Q: I would like to know how to page results in SQL Server pre-2005. For example; I have 10,000 results I want to show 1-50 on the first page, 51-100 on the second page and so on. I can achieve this in SQL Server 2005 by using ROW_NUMBER() and the OVER keyword but this is not supported pre-2005. Thanks.
Bryan Oliver says: Paging results can be diffcult prior to 2005 and there has been much discussion on this on the following websites:
josephlindsay.com/archives/2005/05/27/paging-results-in-ms-sql-server
scottonwriting.net/sowblog/posts/5992.aspx
www.codeproject.com/cs/database/PagingResults.asp
weblogs.sqlteam.com/jeffs/archive/2004/03/22/1085.aspx
Technorati Tags:
SQL Server 2000, SQL Server, josephlindsay.com, scottonwriting.net, codeproject.com, weblogs.sqlteam.com/jeffs
