SQL Code Beautifier for SQL Server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

SQL Code Beautifier for SQL Server

Author

Topic

guidomarcel
Starting Member

5 Posts

Posted - 2005-01-20 : 09:57:18

SQL Code Beautifier

Hello,
maybe you are interested in this.
I wrote a java applet on www.sqlinform.com which is a SQL Code beautifier. It is for all kind of SQL (SQL Server, DB2, ORACLE, Access, Informix, MySQL, etc). The only thing you need is a Java Runtime Environment (which should be available in most cases). You can beautify SQL statements out of program code and / Or format them for Java, ASP, VB, PHP.
Regards
GuidoMarcel

Kristen
Test

22859 Posts

Posted - 2005-01-20 : 11:42:28

When I click FORMAT SQL nothing happens - its probably just me, but.

Kristen

AndyB13
Aged Yak Warrior

583 Posts

Posted - 2005-01-20 : 12:04:49

Kristen
Maybe your code was beautiful already

AndyB13
Aged Yak Warrior

583 Posts

Posted - 2005-01-20 : 12:08:18

Click the clear screen button first and then enter your code or click the example button - that seemed to work for me

Quite impressive

guidomarcel
Starting Member

5 Posts

Posted - 2005-01-20 : 12:10:37

quote:
Originally posted by Kristen

When I click FORMAT SQL nothing happens - its probably just me, but.

Kristen

HI Kristen,
your browser / proxy server (if it is the 1st time you visit www.sqlinform.com then it is your proxy server) is still using an obsolete version. To force him to load the new one, try this

1) empty your IE cache
2) disable proxy server
3) close the browser and restart it
4) reload the page with ctrl+F5

Hopefully this will force the browser to take the latest version from www.sqlinform.com

If you still experience problems please do not hesitate to contact me

Keep me informed!!

Regards
Guido

X002548
Not Just a Number

15586 Posts

Posted - 2005-01-20 : 12:45:39

Can you imagine trying to beautify Rob's code?

Brett

8-)

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2005-01-20 : 14:45:27

Cool applet, gotta love the name "Code Beautifier" hehehe.
I keep wondering what the driving force behind a tool like this could be.

1. why is my tab key not working ?
2. boy am sick of writing this dynamic sql concatenation in vb

?
3. this legacy code looks like sh i t ?

>> Can you imagine trying to beautify Rob's code?
No, it is perfect, no waste of screen estate there, noo man !

rockmoose

guidomarcel
Starting Member

5 Posts

Posted - 2005-01-21 : 17:33:30

quote:
Originally posted by Kristen

When I click FORMAT SQL nothing happens - its probably just me, but.

Kristen

Hi,
I have to admit that there was a problem when using the Microsoft Java Machine. I published a new version of SQLinForm "v1.01" (the new version number should be visible in the bottom right corner). I hope this solves your problems.

Sorry for any inconveniences

Guido

epanther
Starting Member

8 Posts

Posted - 2005-01-21 : 22:16:30

That is a pretty cool tool. I may use it when I get lazy and there is a lot of code to do.

Panther

brandonl
Yak Posting Veteran

58 Posts

Posted - 2005-01-21 : 22:48:58

Very nice. I think I'll bookmark it for later use ;)

Good job!

~BrandonL

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2005-01-22 : 09:46:54

Very nice -- seems to work quite well! very good for cutting and pasting code that people post here at sqlteam that they need help with! Well done.

- Jeff

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources