Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Hi Mike,
Thanks for the response.
Actually, your are right. What I meant to say was after opening a cursor I want to issue a "FETCH ABSOLUTE intPos" to go to a specific record then return the next 100 entries form that cursor, rather than return the whole cursor and have ASP process it.
Any tips...
Thanks,
Mike
>>I am trying to get a result set via a stored procedure that declares a cursor and uses FETCH NEXT to populate the cursor.
>
>This isn't clear to me. Cursors are populated by the FETCH command. Cursors are populated when opened. The FETCH just moves the value of the current position to the variables specified.
>
>-Mike
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement