Page records in SQL server

http://databases.aspfaq.com/database/how-do-i-page-through-a-recordset.html - How do I page through a recordset?

http://databases.aspfaq.com/database/how-do-i-handle-alphabetic-paging.html ---- How do I handle alphabetic paging?

http://msdn2.microsoft.com/en-us/library/ms979197.aspx --- Microsoft Solution

http://www.sqlteam.com/item.asp?ItemID=26455 - Server Side Paging using SQL Server 2005
=========================================
http://www.aspfaq.com/show.asp?id=2120. --- Good site on SQL and this link explains SQL paging
========================================

SQL 2005 books online :: http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

SQL 2000 books online:::: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx