Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dynamic SQL query in a cursor
Message
From
16/03/2001 08:15:09
Michael Levy
Cincinnati, Ohio, United States
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: Dynamic SQL query in a cursor
Miscellaneous
Thread ID:
00485420
Message ID:
00485811
Views:
12
Dynamic SQL has some weird behaviors. SQL Server treats Dynamic SQL as a seperate batch. Is the cursor within scope after the call to EXECUTE()?

BTW, are you sure that there's not a set-oriented solution to your problem?

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform