Is it possible to auto-indent a query in Sql Server Management Studio Express? [closed]

Question

Closed. This question is seeking recommendations for software libraries, tutorials, tools, books, or other off-site resources. It does not meet Stack Overflow guidelines. It is not currently accepting answers.

We don’t allow questions seeking recommendations for software libraries, tutorials, tools, books, or other off-site resources. You can edit the question so it can be answered with facts and citations.

Closed 7 years ago.

Improve this question

I mean, something equivalent to Ctrl + K + D from Visual Studio that automatically indents code. Is there something in this sense?

Thes SQL Formatter at www.sqlinform.com has a window hotkey function which could do the same — Guido
– Guido, Commented Aug 24, 2014 at 18:20

Community · Accepted Answer · 2017-05-23 10:31:16Z

21

Just discovered this - yet another variation on this older question which has much more activity: SQL Formatter for SQL Management Studio

I personally am a big fan of the Poor Man's T-SQL Formatter / http://poorsql.com - but then I wrote it :)

edited May 23, 2017 at 10:31

CommunityBot

11 silver badge

answered Dec 21, 2011 at 15:33

Tao

14.1k7 gold badges70 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

third_eye Over a year ago

Please accept my upvote, kind sir.

Omar and Lorraine Over a year ago

Thank you for making the poor man's tsql formatter. You've saved a lot of hours here.

Orland Mendes · Accepted Answer · 2013-05-30 08:29:35Z

16

By default no but you can always try a third party tools like SQL Prompt mentioned above or ApexSQL Refactor (slightly less options compared to SQL Prompt but it’s a free product) or just use online formatter.

answered May 30, 2013 at 8:29

Orland Mendes

5164 silver badges5 bronze badges

Comments

Mitch Wheat · Accepted Answer · 2012-03-29 11:40:02Z

10

SQL Prompt from Red Gate can do this.

If you just want simple formatting online then the same technology powers FormatSQL.com

edited Mar 29, 2012 at 11:40

user874816

answered Jan 19, 2010 at 1:38

Mitch Wheat

302k44 gold badges482 silver badges552 bronze badges

2 Comments

Dubs Over a year ago

Looks like a great product! It's just too bad it's so pricey! (Around $300 at the time of this post)

TheGateKeeper Over a year ago

Format SQL is great! Thanks! I wonder why there is no inbuilt function for thid.

ChrisWerry · Accepted Answer · 2011-05-12 04:10:06Z

3

SQL Pretty Printer can also reformat SQL. Available as a stand alone app or a SSMS plugin. Free to download (with a nag screen but no other apparent limitations) from http://www.dpriver.com

There is an online version at http://www.dpriver.com/pp/sqlformat.htm?ref=g_wangz

answered May 12, 2011 at 4:10

ChrisWerry

1353 bronze badges

1 Comment

JohnL4 Over a year ago

Standalone download version can't save or be copied to the clipboard.

Guido · Accepted Answer · 2013-05-30 21:54:35Z

1

There is also the SQLinForm formatter. It is an automatic SQL code formatter for all major databases including ORACLE, SQL Server, DB2, UDB, Sybase, Informix, PostgreSQL, Teradata, MySQL, MS Access etc. with over 100 formatting options.It has a windows hotkey add-on, so you can use it in SSMS. Link: www.sqlinform.com

answered May 30, 2013 at 21:54

Guido

1,0402 gold badges12 silver badges24 bronze badges

Collectives™ on Stack Overflow

Is it possible to auto-indent a query in Sql Server Management Studio Express? [closed]

5 Answers 5

2 Comments

Comments

2 Comments

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

Comments

2 Comments

1 Comment

Comments

Linked

Related