March 14, 2002 at 1:26 am
Hi experts,
what is the best way to author and debug the stored procedures with multiple cursors. . or are there any tools to this job easy. .
with rgds.
Girish Patil
March 14, 2002 at 5:26 am
You can use profiler to watch the process, if you are using SQL 2000 there is a debugger, look at BOL in the index for "Transact-SQL Debugger window" for help. Also you may want to get help looking at what you are doing as you should try to avoid any cursor at all (if possible), especially multiple cursors. COnsider what you are doing and how the data relates, then what TSQL items are available to put those pieces together like the cursor would.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Edited by - antares686 on 03/14/2002 05:27:37 AM
March 14, 2002 at 10:12 am
The debugger works great, but if you want you can make the procedure a script and then you can go through it with lots of selects or prints to keep track of what's going on.
Steve Jones
March 14, 2002 at 6:35 pm
Thanks a lot to all for your helpfull tips. . .
cheers.
March 29, 2002 at 3:14 pm
There is a product called sql programmer that is great. Kind of expensive though.
Here is a review, and where to get it:
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply