Efficient paging using SQL script [Tip/Trick]
Posted: 28 Dec 2011
Updated: 28 Dec 2011
Rating: 4.57/5
Votes: 4
Popularity: 2.71
Licence: The Code Project Open License (CPOL)
Bookmarked: 1
Downloaded: 0
Hi, what about such solution?DECLARE @pageNumber INTDECLARE @rowsOnPage INTSET @rowsOnPage=5SET @pageNumber=2DECLARE @totalItemsToSelect INTSET @totalItemsToSelect=@rowsOnPage * @pageNumberSELECT TOP (@rowsOnPage) * FROM MainTrans WHERE ID IN( SELECT TOP...