Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Browsing the results of a cursor in a stored procedure
Message
 
 
To
20/12/2006 11:11:43
Stephen Hunt
Admit Computer Services Inc.
Farmingdale, New York, United States
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
01179225
Message ID:
01179237
Views:
9
>Is there any way that I can browse the results of a cursor in a stored procedure. I am using Declare temp_Cursor CURSOR SCROLL FOR select * from temptable
>then after the cursor is executed I would like to browse the result set so I can make sure the data is accurate.

A data in a cursor can anly be accessed with FETCH command. See Re: USE command in SP Message #1057625 for an alternatrive method of processing records.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform