By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,806 Members | 1,841 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,806 IT Pros & Developers. It's quick & easy.

SQL Analyzer

P: n/a

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.

Jul 23 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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.

Jul 23 '05 #2

P: n/a
"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.

Jul 23 '05 #3

P: n/a
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 ...

Jul 23 '05 #4

P: 3
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.
Hi,
maybe you can try the free online SQL Formatter called SQLinForm at http://www.sqlinform.com . It has the possibility to add line numbers to the SQL statement. You can use the version 1 with most computers as this Java applet is working with the very early versionof Java Runtime Environment 1.1 . The applet allows to format SQL statements independently from the DB used and you can format SQL code out of program code and / or format it for many different languages.

Hope this helps
Guido
Sep 14 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.