SQL SERVER – Server Side Paging in SQL Server Denali – A Better Alternative

Ranking has improvement considerably from SQL Server 2000 to SQL Server 2005/2008 to SQL Server 2011.

Now SQL Server 2011 has come up with the new Syntax for paging. Here is how one can easily achieve it.

USE AdventureWorks2008R2
GO
DECLARE @RowsPerPage INT = 10, @PageNumber INT = 5
SELECT *
FROM Sales.SalesOrderDetail
ORDER BY SalesOrderDetailID
OFFSET @PageNumber*@RowsPerPage ROWS
FETCH NEXT 10 ROWS ONLY
GO

I consider it good enhancement in terms of T-SQL. I am sure many developers are waiting for this feature for long time.

Posted in: SQL Server,SQL Server side paging