473,322 Members | 1,480 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

SQL Analyzer


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
4 1514
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
"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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: joh12005 | last post by:
Hello, here is a trouble that i had, i would like to resolve it with python, even if i still have no clue on how to do it. i had many small "text" files, so to speed up processes on them, i...
5
by: Warren Wright | last post by:
Hi group, I have a select statement that if run against a 1 million record database directly in query analyzer takes less than 1 second. However, if I execute the select statement in a stored...
1
by: Alex Cicco | last post by:
Hi, I am new to SQL. Please bear with me and allow me to ask a dumb question. I am debugging a stored procedure (written in Trans-SQL), and I found that the SQL analyzer that I use doesn't...
0
by: kackson | last post by:
Hi. I've been using SQL server 2000's query analyzer and the enterprise manager without problems for quite some time (2 months). And all of a sudden one week ago, when I started the query analyzer...
2
by: Poster | last post by:
After creating an IN clause from a bunch of character strings created by a Word macro, Query Analyzer complains about a syntax error. The macro takes a column full of character strings and wraps...
3
by: JM | last post by:
Good day. I was able to connect to a database server using SQL Server Enterprise Manager. The Server name specified on the tree is JOMARGON(Windows NT). But no server was detected using either...
1
by: justinjoylife | last post by:
Hi - I'm completely new to Microsoft Query Analyzer and I need to learn it for work to do data mining as a Product Manager. Does anyone have any recommendations on how to learn this and where?...
1
by: Chris Morse | last post by:
Does anyone know how to profile a VB.NET application? In the VS.NET 2003 docs, I found this: (BEGIN DOC COPY) "A code profiler is a software tool, implemented as a DLL, which is called by...
14
by: Kevin G. Anderson | last post by:
What: CAUG Meeting - QuickBooks IIF Files; Total Access Analyzer; CAUG Social When: Thursday, May 25, 2006, 6PM Who: Chris Monaghan and Kevin Anderson Where: The Information Management Group...
0
by: serdar | last post by:
Hi I'm designing a spectrum analyzer for a flash media player using the new computeSpectrum method in AS3. There are two basic types of visualizers I'm working on: -wave-type (displays a sound...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.