Sql indentation in SQL Server Management Studio [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. 开发者_StackOverflow社区

---

We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

Closed 4 years ago.

Improve this question

Folks, is there a tool to format/indent SQL Server queries in query window ?

---

With Apex SQL Refactor, you can specify your formatting preferences and reformat selected code or the entire window at any time using a keyboard shortcut. There's a free version.

---

+1 to JackM.

Just add a mention for some other (not free) tools available from Red Gate, depending on exact requirements.

SQL Prompt
SQL Refactor

Might be something you'd be interested in.

---

Format code in SQL Management Studio

---

Older question which has much more activity and more answers: SQL Formatter for SQL Management Studio

My contributon to this mess is Poor Man's T-SQL Formatter / http://poorsql.com - free, open-source, does bulk formatting from command-line, SSMS plugin, etc, and (in theory) handles all SQL syntax up to SQL Server 2008 (R2).