SQL Server Paging Query

New methods introduced by SQL Server 2005.

SELECT * FROM (select Row_number () Up (ORDER by Keyfield DESC) as RowNum, * from TableName) as T WHERE rowNum > start and RowNum <= End

which

Keyfield is a field of table TableName (preferably a primary key);

TableName is the name of the table queried;

Desc can be changed to ASC on demand;

Start is the beginning record of the result set to be taken, and end is the ending record of the result set to be taken, which can be computed by: (Start + pageSize).