如何自动格式化SQL Server代码？ [英] How to automatically format SQL Server code?

问题描述

我可以使用任何工具来格式化SQL Server代码吗？我想找一个快速而肮脏的解决方案，我可以打开脚本，点击格式然后保存。

Is there any tool I can use to format SQL Server code? I’d like to find a quick and dirty solution where I can just open script, click format and then save it.

推荐答案

有很多工具......



试试这个开源选项 http://sourceforge.net/projects/fsqlf / [ ^ ]



和Pinal Dave有关于主题的博客http://blog.sqlauthority.com/2007/05/20/sql-server-sql-code-formatter-tools/ [ ^ ]



Google也会为您提供多种（免费）在线工具。

There are loads of tools ...

Try this opensource option http://sourceforge.net/projects/fsqlf/[^]

and Pinal Dave has a blog on the very subject http://blog.sqlauthority.com/2007/05/20/sql-server-sql-code-formatter-tools/[^]

Google will present you with several (free) on-line tools too.

您可能想尝试 ApexSQL Refactor [ ^ ]据我所知，它适用于所有SQL Server版本并且它是免费的。

You might want to try ApexSQL Refactor[^] As far as I know it works with all SQL server versions and its free.

这篇关于如何自动格式化SQL Server代码？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！