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.
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).
发布评论
评论（4）
使用 Apex SQL Refactor，您可以随时指定格式化首选项并重新格式化所选代码或整个窗口使用键盘快捷键的时间。有一个免费版本。
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 给 JackM。
只需根据具体要求添加 Red Gate 提供的其他一些（非免费）工具即可。
SQL 提示
SQL 重构
可能是您感兴趣的内容。
+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.
在 SQL Management Studio 中设置代码格式
Format code in SQL Management Studio
较旧的问题有更多的活动和更多的答案：SQL Formatter for SQL Management Studio
我对这个混乱的贡献是Poor Man's T-SQL Formatter / http://poorsql.com - 免费、开源，从命令行、SSMS 插件等进行批量格式化，并且（理论上）处理 SQL Server 2008 (R2) 之前的所有 SQL 语法。
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).