|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
how to display 10 rows at a time when 1000's returned form sql queryhow to display 10 rows at a time when 1000's returned form sql query
how to select the 20th-30th row in a where clause? e.g. select the 20th to 30th employee who name is 'bob' in tsql. i need this because my select often returns 1000s of rows and i want to display them in pages of 10 at a time but without loading all 1000's into the web app at once! Daniel
http://www.aspfaq.com/show.asp?id=2120 Show quote "Daniel" <softwareengineer98***@yahoo.com> wrote in message news:eHZqRqriGHA.3884@TK2MSFTNGP04.phx.gbl... > how to display 10 rows at a time when 1000's returned form sql query > > how to select the 20th-30th row in a where clause? e.g. select the 20th to > 30th employee who name is 'bob' in tsql. i need this because my select > often returns 1000s of rows and i want to display them in pages of 10 at a > time but without loading all 1000's into the web app at once! >  |
|||||||||||||||||||||||
Other interesting topics