用于 Intellisense/Autoformat 的 SQL Management Studio 插件？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/4594827/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
SQL Management Studio Plug-ins for Intellisense/Autoformat?
提问by Ocelot20
Are there any free, or cheap plug-ins/add-ons for SQL Management Studio that provide intellisense and (less importantly) some auto-formatting? I've recently tried Redgate's product and really like it for these features, but I'm wondering if there are any alternatives.
是否有任何免费或廉价的 SQL Management Studio 插件/附加组件提供智能感知和（不太重要的）一些自动格式化？我最近尝试了 Redgate 的产品，并且非常喜欢它的这些功能，但我想知道是否有其他选择。
采纳答案by bernd_k
I think ssms toolspack is what you are looking for. I use it myself. Works from sql-server 2005+
我认为ssms toolspack是您正在寻找的。我自己用。从 sql-server 2005+ 开始工作
回答by Gabi985
Late answer, but might be interesting to the thread visitors
迟到的答案，但可能对线程访问者感兴趣
Have you heard of ApexSQL Free tools - ApexSQL Complete and ApexSQL Refactor? These might be just what you need.
您是否听说过 ApexSQL 免费工具 - ApexSQL Complete 和 ApexSQL Refactor？这些可能正是您所需要的。
ApexSQL Completeautocompletes SQL keywords, and has a ton of other SQL Server productivity features for SSMS and Visual Studio, and it is completely free.
ApexSQL Complete 会自动完成 SQL 关键字，并为 SSMS 和 Visual Studio 提供大量其他 SQL Server 生产力功能，并且完全免费。
ApexSQL Refactoris SQL formatter with over 160 formatting options - it is too completely free.
ApexSQL Refactor是具有 160 多个格式化选项的 SQL 格式化程序 - 它太完全免费了。
Both of these are SQL Server Management Studio and Visual Studio plugins, so you can use them directly from within SSMS and VS.
这两个都是 SQL Server Management Studio 和 Visual Studio 插件，因此您可以直接从 SSMS 和 VS 中使用它们。
回答by Devart
Check out our dbForge SQL Complete. It is an add-in for SSMSthat offers autocompletion and formatting of T-SQL code and supports SQL Server 2000, 2005 and 2008
查看我们的dbForge SQL Complete。它是 SSMS 的插件，提供 T-SQL 代码的自动完成和格式设置，并支持 SQL Server 2000、2005 和 2008
Recently we have released a new major version (2.00) which includes much more new features.
最近我们发布了一个新的主要版本 (2.00)，其中包含更多新功能。
There's two editions – Express, which is free and has basic autocomplete and formatting functionality, while Standard Edition offers more features, has 30-days free trial and costs only $49.95.
有两个版本——Express，它是免费的，具有基本的自动完成和格式化功能，而标准版提供更多功能，有 30 天的免费试用期，只需 49.95 美元。
回答by TGnat
I am a big fan of the Red-Gatetools.
我是Red-Gate工具的忠实粉丝。
SQL Server 2008 has some of the intellisense built in when working with compatible servers. I've heard of but never tried the SMSS Tools Pack.
SQL Server 2008 在使用兼容服务器时内置了一些智能感知。我听说过但从未尝试过SMSS Tools Pack。
回答by Leroy Kahn
For Intellisensestyle suggestions db Forge SQL Complete (Free Edition)works great for me. No lag in Management Studio that I experienced with some of the other free add-ins like SQL Prompt.
对于Intellisense风格建议，db Forge SQL Complete（免费版）对我来说非常有用。我在使用SQL Prompt等其他一些免费加载项时没有遇到 Management Studio 中的滞后。
Didn't agree 100% with the Formatter so just don't use it.
不同意 Formatter 100% 所以不要使用它。
DB: SQL Server 2005
IDE: SQL Server Mgmt Studio 2008 R2 & Visual 2008 Team Suite
数据库：SQL Server 2005
IDE：SQL Server Mgmt Studio 2008 R2 & Visual 2008 Team Suite
