How to do database pagination

• Stylez

  SSCrazy

  Points: 2195

  More actions

  June 1, 2008 at 9:55 pm

  #187329

  Good Morning Folks,

  i would like to kindly ask if you could give me an overview of what databse pagination means, and how it works. can it improve the overall performance of my stored procedure? please send me your recommendation based on the Sample stored procedure that i've attached. any form of help will be gladly appreciated.

  Thank you And Best Regards,

  Noel

• jaypee_s

  Right there with Babe

  Points: 793

  More actions

  June 2, 2008 at 5:51 am

  #822845

  hi

  This link may be useful to you

  http://www.singingeels.com/Articles/Pagination_In_SQL_Server_2005.aspx

  Thanks

  jaypee.s

• Goldie Lesser

  SSCertifiable

  Points: 6155

  More actions

  June 3, 2008 at 9:05 am

  #823686

  Some more links that may be helpful:

  http://aspadvice.com/blogs/jlovell/archive/2004/09/15/1992.aspx

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50945