Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Obtaining result set form SP using cursors
Message
From
24/06/2002 18:41:15
 
 
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00671813
Message ID:
00671859
Views:
23
Hi Mike,

Also, do you know why the Query Analyzer would give me a "Result Grid" for each row returned from the cursor?

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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform