Efficient paging using SQL script

kamiktk123

Rate me:

0.00/5 (No votes)

10 Jan 2012CPOL

7.8K

string Query = string.Format(@"SELECT * FROM (SELECT *, " + @"ROW_NUMBER() OVER(ORDER BY PRODUCT_ID DESC ) AS ROW_NUM FROM({0}) " + @"AS TEMP_INNER) AS TEMP_OUTER WHERE ROW_NUM BETWEEN '{1}' AND " + @"({2} + {3}) - 1", strSql, startRowIndex, startRowIndex, maximumRows);

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

1. Efficient paging using SQL script

16 Jan 2012Robby Tendean

3 alternatives

How to create an efficient paging using SQL script

T-SQL

SQL

SQL-Server

2. Efficient paging using SQL script

10 Jan 2012jeantoledo

Take a look at this:DECLARE @ActualRow = 1; /*Start in first item*/DECLARE @ItensCount = 100; /*100 itens for page*/DECLARE @Page = 1; /*Start in first page*/SELECT * FROM(SELECT *, ROWNUMBER() OVER(ORDER BY Name) as ROWNUM FROM Users) as UsWHERE ROWNUM BETWEEN...

T-SQL

SQL

SQL-Server

3. Efficient paging using SQL script

28 Dec 2011NeoPunk

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...

T-SQL

SQL

SQL-Server

License

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

Written By

kamiktk123

Software Developer PowerObjects

Pakistan

I am a professional Software Developer. I have experience in developing Windows Applications, e-commerce Portals, Content Management Systems and Data driven websites.
My technical forte includes: C#, ASP.NET, ADO.NET, JavaScript, jQuery, SQL Server, Design Patterns.
My interests involves programming, website development, developing applications for Android and learning subjects related to Software Engineering/Information Systems. Currently I am working as a Software Engineer at PowerObjects Pvt Ltd.

Efficient paging using SQL script

Alternatives

License

Comments and Discussions