sql server connect: SELECT returns too many rows -- sql server connect

RE: SELECT returns too many rows

Alejandro Mesa
3/24/2005 11:37:02 AM

sql server connect:

How do I page through a recordset?
http://www.aspfaq.com/show.asp?id=2120

AMB

[quoted text, click to view]

SELECT returns too many rows

hide.me NO[at]SPAM nowhere.com
3/24/2005 5:54:02 PM

We have a web service that accesses an SQLServer database. The database has
hundreds of thousands of rows.

We open a cursor in order to allow the user to page through output, but
processing takes too long and the cursor consumes too much memory.

I understand how to limit the return set by using "TOP n." What I need to be
able to do is retrieve the first hundred rows satisfying a certain
conditional, then retrieve rows 101 to 200, etc. Is there a way to page

Re: SELECT returns too many rows

hide.me NO[at]SPAM nowhere.com
3/24/2005 8:48:41 PM

Thank you!

On 24-Mar-2005, "=?Utf-8?B?QWxlamFuZHJvIE1lc2E=?="
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server connect group.