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 6 years ago.
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
接受
或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
发布评论
评论(5)
刚刚发现了这个 - 这个旧问题的另一个变体,它有更多的活动: SQL Formatter for SQL Management Studio
我个人是 Poor Man's T-SQL Formatter 的忠实粉丝/ http://poorsql.com - 但后来我写了它:)
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 :)
默认情况下不会,但您始终可以尝试第三方工具,例如上面提到的 SQL Prompt 或 ApexSQL Refactor (与 SQL Prompt 相比,选项略少,但它是免费产品)或仅使用在线格式化程序。
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.
Red Gate 的 SQL Prompt 可以做到这一点。
如果您只想进行简单的在线格式化,那么同样的技术也可以FormatSQL.com
SQL Prompt from Red Gate can do this.
If you just want simple formatting online then the same technology powers FormatSQL.com
SQL Pretty Printer 还可以重新格式化 SQL。可作为独立应用程序或 SSMS 插件使用。 从 http://www.dpriver.com 免费下载(带有导航屏幕,但没有其他明显限制)
可 是在线版本,位于 http://www.dpriver.com/pp/sqlformat。 htm?ref=g_wangz
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
还有 SQLinForm 格式化程序。它是一个自动 SQL 代码格式化程序,适用于所有主要数据库,包括 ORACLE、SQL Server、DB2、UDB、Sybase、Informix、PostgreSQL、Teradata、MySQL、MS Access 等,具有超过 100 个格式化选项。它有一个 Windows 热键附加组件,所以你可以在SSMS中使用它。链接:www.sqlinform.com
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