How many times have you seen SQL code in an application that is not formatted in a manor that allows for easy reading. Many times you extracted running SQL queries from within your databases that was causing a performance issue but is presented to you in an un-readable form.
Under these conditions, wouldn't it be nice to NOT have to spend the next hour formatting the SQL just so that you can read it and begin your evaluation?
Just so happens I was tooling around the net over the weekend and came across a tool that will allow you to paste in your ugly SQL and have it return beautifully formatted SQL. All for Free!
I searched "SQL Beautifier" and found Instant SQL Formatter online and it is a pretty handy free online tool. Here is the link to the free online Instant SQL Formatter:
http://www.dpriver.com/pp/sqlformat.htm
Just go to the web site and give it a try. Desktop version is also availabe and it support all major development enviroments including Microsoft Query Analyzer, SQL Server Management Studio (SSMS), TOAD and PL/SQL Developer, development environments such as Visual Studio 2003/2005 and Eclipse, and popular editors such as UltraEditor and EditPlus.
http://www.wangz.net/sqlpp.php
Saturday, August 29, 2009
Subscribe to:
Posts (Atom)
