Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Titre:
Obtaining result set form SP using cursors
Hi All,
I am trying to get a result set via a stored procedure that declares a cursor and uses FETCH NEXT to populate the cursor. The problem is that the result set that is returned is a table for each row fetched.
I just ran SQL Server Service Pack 4 and prior to that I remember the FETCH procedure returning a complete dataset with rows in a single table, and not a table for each row fetched.
Any ideas?
Thanks,
Mike
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