SEO

#1 (**permalink**) 02-29-2008, 05:16 AM

Is there any similar tool that provides more helpful debugging info
than SQL Analyzer? When one write hundred and hundres lines of code
for some heavy duty task, it's almost inevitable that typo and the like
happens, so, easy INDENT and LINE NUMBERING is very helpful for a tool.
TIA.

#2 (**permalink**) 02-29-2008, 05:17 AM

You can use Visual Studio 2003. Create a datsource connection. Then
open server explorer. Find your SP then right-click to edit. You can
debug etc... I personally never use it as I find VS extremely
slooowwww.

With MSSQL 2000, I breakup long procedures by using UDFs that return a
table. My "main" stored procedure consist of calls to the UDFs.

#3 (**permalink**) 02-29-2008, 05:17 AM

"I breakup long procedures by using UDFs that return a
table. My "main" stored procedure consist of calls to the UDFs"
That's interesting, sort of modularizing complex sp.

#4 (**permalink**) 02-29-2008, 05:17 AM

UDFs have many restrictions but I find them quite useful. I frequently
write stuff like the following, where the UDFs contains all kinds of
nasty code. You can even nest UDFs, although I try not to get carried
away with it.
select ...
from myUdfA(@params)
join myUdfB(@params)
on ...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode