Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Execute script one line at a time
Message
 
 
To
11/06/2008 11:05:12
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Microsoft SQL Server
Category:
Database management
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01323060
Message ID:
01323107
Views:
11
>>>Is there a way to execute a script one line at a time in the SQL Server Management Studio? Like I can in the Foxpro debugger? Can I also see values/results as it is executing?
>>
>>You can highlight the line and try to execute it. I'm not sure there is another way.
>
>What about seeing the results of a cursor?
>
>I've basically got this (much code removed):
>
>
>Declare MyTable cursor
>
>Select blah blah blah
>
>Open MyTable
>
>
>How do I view this or see the results?

If you only do SELECT, then you'll see the results. With CURSOR I'm not sure.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform