TSQL: Pagination data with OFFSET and FETCH in SQL Server 2012

Scenarios In the prior SQL edition, you often use combination of ROW_NUMBER and ORDER BY whenever you want to implement pagination data in SQL Server. From SQL Server 2012, Microsoft announced a new functions to support pagination data. They are OFFSET and FETCH. In this article, I am going to introduce how to use them for … Continue reading TSQL: Pagination data with OFFSET and FETCH in SQL Server 2012