Click here to Skip to main content
Click here to Skip to main content
Add your own
alternative version

Tagged as

Efficient paging using SQL script

, 28 Dec 2011 CPOL
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...

Revisions


  

Compare Revision Minor Date Status Editor
3 - publicly available No 28-Dec-11 7:38 Available NeoPunk
2 No 28-Dec-11 7:34 Available NeoPunk
1 No 28-Dec-11 7:31 Available NeoPunk

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author


| Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.150128.1 | Last Updated 28 Dec 2011
Article Copyright 2011 by NeoPunk
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid