Auto Indentation

Question

Post reply

Auto Indentation

Anam Verma

SSCertifiable

Points: 5365
More actions
July 30, 2008 at 5:35 pm

#190392

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.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 1

Try one of these:

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

or

http://www.sqlinform.com/

[font="Verdana"]Markus Bohse[/font]

Atif-ullah Sheikh SSChampion Points: 12495 More actions · Answer 2

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 [font="Arial Black"]here[/font][/url][/right]

Grant Fritchey SSC Guru Points: 398909 More actions · Answer 3

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/[/url]

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Anam Verma SSCertifiable Points: 5365 More actions · Answer 4

Thanks All. Appreciate your quick response for big help. 🙂

thbaig Hall of Fame Points: 3006 More actions · Answer 5

a free tool with option to customize

http://www.apexsql.com/sql_tools_refactor_features.aspx

Sarah Wagner Hall of Fame Points: 3178 More actions · Answer 6

I use a free plug in for SSMS... http://www.tsqltidy.com/ It works pretty good.