Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
A cursor already exists
Message
 
 
To
05/03/2008 09:43:33
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
01298878
Message ID:
01298891
Views:
14
>>Do you mean you would try to deallocate cursor that didn't exist? Let me try, though you can always use TRY/CATCH in 2005.
>>
>>Well, it did produce an error if the variable was not declared:
>>
>>Must declare the scalar variable "@myCursor".
>
>Yes, TRY/CATCH would have done it. But, Sergey mentioned to declare it local which is exactly what I need.

I'm getting 'Incorrect syntax near 'local'. ' in my tries. Does it work for you?
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform