Using Query Paging in SQL Server 2012
In this post I will be looking into a new feature in SQL Server 2012. Actually this is a T-SQL enhancement and it is called Query Paging.Often in our applications we need to page/select a number of rows (or a range of rows if you prefer) by specifying a row count offset in the results. I will be introducing OFFSET which specifies the number of rows to skip before starting and FETCH which specifies the number of rows after the OFFSET to return.We will use OFFSET/FETCH NEXT in combination with the ORDER BY clause. (
read more)