Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
A cursor already exists
Message
 
 
À
05/03/2008 09:43:33
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
01298878
Message ID:
01298891
Vues:
15
>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform