>>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?