Posted by: jwalin on: April 15, 2008
With Microsoft SQL Server 2005, paging on the database side is simple. There is a built-in ROW_NUMBER function designed specifically for this task. However, versions of SQL Server prior to 2005 do not have this capability. Below is one way to implement similar functionality in pre-2005 versions.
SELECT TOP X * FROM RECORDS WHERE RecordID [...]
