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的产品，并且非常喜欢它的这些特性，但是我想知道是否还有其他的选择。
5 个解决方案
#1
8
I think ssms toolspack is what you are looking for. I use it myself. Works from sql-server 2005+
我想ssms toolspack就是你要找的。我自己使用。作品从sql server 2005 +
#2
32
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完整和ApexSQL重构吗?这些可能正是你所需要的。
ApexSQL Complete autocompletes SQL keywords, and has a ton of other SQL Server productivity features for SSMS and Visual Studio, and it is completely free.
ApexSQL完整的自动完成SQL关键字，并且为SSMS和Visual Studio提供了大量其他SQL服务器生产力特性，并且是完全免费的。
ApexSQL Refactor is SQL formatter with over 160 formatting options - it is too completely free.
ApexSQL Refactor是一个SQL格式化程序，有超过160个格式化选项——它是完全免费的。
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插件，所以您可以直接从ssm和VS中使用它们。
#3
18
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美元。
#4
7
I am a big fan of the Red-Gate tools.
我是红门工具的忠实粉丝。
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工具包。
#5
0
For Intellisense style 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.
对于智能感知风格的建议，db Forge SQL Complete(免费版)对我来说非常有用。我在管理Studio中体验过一些免费的附加组件，比如SQL Prompt，没有任何延迟。
Didn't agree 100% with the Formatter so just don't use it.
不完全同意格式化程序，所以不要使用它。
DB: SQL Server 2005
DB:SQL Server 2005
IDE: SQL Server Mgmt Studio 2008 R2 & Visual 2008 Team Suite
IDE: SQL Server Mgmt Studio 2008 R2 & Visual 2008 Team Suite
#1
8
I think ssms toolspack is what you are looking for. I use it myself. Works from sql-server 2005+
我想ssms toolspack就是你要找的。我自己使用。作品从sql server 2005 +
#2
32
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完整和ApexSQL重构吗?这些可能正是你所需要的。
ApexSQL Complete autocompletes SQL keywords, and has a ton of other SQL Server productivity features for SSMS and Visual Studio, and it is completely free.
ApexSQL完整的自动完成SQL关键字，并且为SSMS和Visual Studio提供了大量其他SQL服务器生产力特性，并且是完全免费的。
ApexSQL Refactor is SQL formatter with over 160 formatting options - it is too completely free.
ApexSQL Refactor是一个SQL格式化程序，有超过160个格式化选项——它是完全免费的。
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插件，所以您可以直接从ssm和VS中使用它们。
#3
18
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美元。
#4
7
I am a big fan of the Red-Gate tools.
我是红门工具的忠实粉丝。
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工具包。
#5
0
For Intellisense style 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.
对于智能感知风格的建议，db Forge SQL Complete(免费版)对我来说非常有用。我在管理Studio中体验过一些免费的附加组件，比如SQL Prompt，没有任何延迟。
Didn't agree 100% with the Formatter so just don't use it.
不完全同意格式化程序，所以不要使用它。
DB: SQL Server 2005
DB:SQL Server 2005
IDE: SQL Server Mgmt Studio 2008 R2 & Visual 2008 Team Suite
IDE: SQL Server Mgmt Studio 2008 R2 & Visual 2008 Team Suite