In this post, I am sharing a demo on SQL Server 2012 Pagination or Custom paging query using OFFSET and FETCH. Whenever thousands or millions of rows are returning from a database at that time paging is required. Using custom paging, we can return only limited data for a particular page. For example, database stored … Continue reading SQL Server 2012: Custom paging using OFFSET and FETCH NEXT