techiekiwi
Programmer
i know you can return the top so many rows using SELECT TOP [n] FROM
. is there any way of returning the NEXT [n] rows?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
returning next rows.
- Thread starter techiekiwi
- Start date
- Status
You will need to use a cursor or place a column in the table that lets you select between certain values. I'm sure there can be a number of other ways to do it as well, but there is no NEXT type of functionality.
You can do this in ADO, however using the CacheSize property in a recordset object...
Tom Davis
tdavis@sark.com
You can do this in ADO, however using the CacheSize property in a recordset object...
Tom Davis
tdavis@sark.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question