DDL gets especially ugly. Is there any option of SQL auto-indenting for Notepad++? I've tried to do it in Eclipse, but the code doesn't react to auto-indent.
DDL变得特别丑。对于Notepad++是否有SQL自动缩进选项?我已经在Eclipse中尝试过了，但是代码对自动缩进没有反应。
2 个解决方案
#1
98
Yes, there is a free/open-source T-SQL formatting plugin for Notepad++, called "Poor Man's T-SQL Formatter". It is available in the NPP "Plugin Manager" plugin list (gets updated every once in a while automatically), and is also available for manually downloading/installing from here: http://www.architectshack.com/PoorMansTSqlFormatter.ashx
是的，有一个免费的/开源的T-SQL格式化插件，叫做“穷人的T-SQL格式化程序”。它可以在NPP“插件管理器”插件列表中找到(每隔一段时间自动更新一次)，也可以从这里手动下载/安装:http://www.architect tshack.com/poormanstsqlformat .ashx
If you just want to check it out without adding to notepad++, you can check the online formatting site:
如果你只是想在不添加notepad++的情况下查看它，你可以查看在线格式网站:
http://poorsql.com
(disclaimer: I wrote these tools :))
(免责声明:我编写了这些工具:)
#2
2
There is also another free SQL Formatter plugin for Notepad++ with code folding and coloring and 100+ formatting option here: SQLinForm Free Notepad++ Plug-n. A free version is also available.
还有另一个用于记事本++的免费的SQL Formatter插件，其中有代码折叠和着色，还有100+格式选项:SQLinForm免费记事本++插件-n。也有免费的版本。
#1
98
Yes, there is a free/open-source T-SQL formatting plugin for Notepad++, called "Poor Man's T-SQL Formatter". It is available in the NPP "Plugin Manager" plugin list (gets updated every once in a while automatically), and is also available for manually downloading/installing from here: http://www.architectshack.com/PoorMansTSqlFormatter.ashx
是的，有一个免费的/开源的T-SQL格式化插件，叫做“穷人的T-SQL格式化程序”。它可以在NPP“插件管理器”插件列表中找到(每隔一段时间自动更新一次)，也可以从这里手动下载/安装:http://www.architect tshack.com/poormanstsqlformat .ashx
If you just want to check it out without adding to notepad++, you can check the online formatting site:
如果你只是想在不添加notepad++的情况下查看它，你可以查看在线格式网站:
http://poorsql.com
(disclaimer: I wrote these tools :))
(免责声明:我编写了这些工具:)
#2
2
There is also another free SQL Formatter plugin for Notepad++ with code folding and coloring and 100+ formatting option here: SQLinForm Free Notepad++ Plug-n. A free version is also available.
还有另一个用于记事本++的免费的SQL Formatter插件，其中有代码折叠和着色，还有100+格式选项:SQLinForm免费记事本++插件-n。也有免费的版本。