Server Side Paging in SQL Server 2011 –Denali

--Create By : Nilay Mistry
--Date         : 02-Jun-2011

DECLARE @RowsPerPage INT = 10,

DECLARE @PageNumber INT = 5


SELECT * FROM EmployeeMaster
ORDER BY EmployeeID
OFFSET @PageNumber*@RowsPerPage ROWS
FETCH NEXT 10 ROWS ONLY
GO