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:
01181604
Views:
7
>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.
>
>Thanks for you help !
>Stephen J. Hunt

You could by fetch line write the contents to another #Temp table and view it.

But no not really.

You know that you should avoid cursors at all costs don't you? ;0
Previous
Reply
Map
View

Click here to load this message in the networking platform