If you want to paginate results in SQL Server 2005 or later, then you may be interested in this piece of SQL query:
SELECT *
FROM (SELECT ROW_NUMBER()
OVER (ORDER BY ItemID DESC)
AS Row, *
FROM Items)
AS WithRowNumbers
WHERE Row >= 1 AND Row <= 100
Change ItemID by your table primary key and change Items by your table name. Also, replace 1 and 100 depending on the range you want to retrieve. The previous query will return rows from 1 to 100.
