pagination query for MSSQL

• Ramandeep Singh-420625

  SSC Enthusiast

  Points: 122

  More actions

  April 6, 2007 at 11:40 am

  #177148

  hi i need to know the pagination query for MS sql , we got a table with more than i million records and when we any query it returns thousands of results, i need to do pagination so that i can break the results into pages.

  i am using php and querying ms sql table.

  thanx very much!

• David Scotland-132255

  SSCertifiable

  Points: 5599

  More actions

  April 6, 2007 at 12:29 pm

  #699078

  If you are using sql server 2005 you can achieve this by using the row number function and then using the row number to return a subset of the data based on its row number.

  Here's a couple of artcles which give examples of how to do this

  http://www.davidhayden.com/blog/dave/archive/2005/12/30/2652.aspx

  http://www.sqlteam.com/item.asp?ItemID=26455

  http://aspnet.4guysfromrolla.com/articles/031506-1.aspx

   

  hth

   

  David