How To … Rotating Header Image

Implement pagination with SQL Server 2005

Jan 9th, 2007
by pjdc.

With the new row_number() feature of the MS SQL Server 2005, now it’s very easy to implement pagination: get data rows page by page to avoid the retrieve too much data at same time. The new feature it’s very similar to the Oracle ROWUM.
The prepare statement could be like the follow:

SELECT * FROM ( SELECT row_number() OVER (ORDER BY id) as resultNum, id FROM table_name) as numberResultsWHERE resultNum  BETWEEN ? AND ?

More information here.

Technorati Tags: ,

Posted in: database.
Tagged:

←
→

4 Comments

  1. aruntyagi says:
    October 30, 2007 at 9:29 am

    Tell me in details how to Implement Pagination with code

  2. Ruben Zevallos Jr. says:
    December 1, 2008 at 4:29 am

    Thanks for the tip

  3. Ramesh Gopalan says:
    April 25, 2009 at 4:07 am

    aruntyagi :Tell me in details how to Implement Pagination with code

    Hi Aruntyagi……

    Please find the code implementaion.

    Ramesh.

  4. Casiva Agustin says:
    August 13, 2009 at 12:54 pm

    I think that is not easy, but it’s what we have. Easy it’s the way that MySQL do, like example

    SELECT * FROM myTable LIMIT ? OFFSET ?

    That is beautiful Query, with a sintax very easy to read. I hope that Microsoft improve this feature in the next versions.

Leave a Reply