Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Auto Indentation Expand / Collapse
Author
Message
Posted Wednesday, July 30, 2008 5:35 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, November 10, 2014 8:55 PM
Points: 528, Visits: 1,274
i have hundreds of sql scripts written with poor indentaion. its very hard to read. instead of indenting each and every lengthy sql script, is there any text editor in market which will do auto identation for the supplied sql scripts.
Post #543979
Posted Thursday, July 31, 2008 3:42 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 2:05 AM
Points: 4,427, Visits: 4,178
Try one of these:

http://www.wangz.net/cgi-bin/pp/gsqlparser/sqlpp/sqlformat.tpl
or

http://www.sqlinform.com/


Markus Bohse
Post #544207
Posted Thursday, July 31, 2008 3:51 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, November 14, 2014 12:37 PM
Points: 3,244, Visits: 5,007
I was looking for the reply of this post...
Nice tool found.

Thanks Markus Bohse



Atif Sheikh


----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Sometimes, winning is not an issue but trying.

You can check my BLOG here

Post #544212
Posted Thursday, July 31, 2008 5:32 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:38 PM
Points: 13,999, Visits: 28,378
The newest version of Red Gate's SQL Prompt will do that for you and lots more. Also Red Gate's SQL Refactor has a way to clean up the layout of code. If nothing else, here's a quick, free, utility to do the same:

http://www.simple-talk.com/sql/sql-tools/the-simple-talk-sql-prettifier/


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #544291
Posted Thursday, July 31, 2008 6:37 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, November 10, 2014 8:55 PM
Points: 528, Visits: 1,274
Thanks All. Appreciate your quick response for big help. :)
Post #544324
Posted Wednesday, January 22, 2014 12:04 PM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 11:26 AM
Points: 78, Visits: 252
a free tool with option to customize

http://www.apexsql.com/sql_tools_refactor_features.aspx
Post #1533789
Posted Wednesday, January 22, 2014 12:08 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 9:43 AM
Points: 1,356, Visits: 631
I use a free plug in for SSMS... http://www.tsqltidy.com/ It works pretty good.
Post #1533791
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse