SQL Management Studio Plug-ins for Intellisense/Autoformat?

sql plugins intellisense ssms add-on
Ocelot20 picture Ocelot20 · Jan 4, 2011 · Viewed 39.1k times · Source

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.

Answer

Gabi985 picture Gabi985 · Jul 15, 2015

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 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 Refactor is SQL formatter with over 160 formatting options - it is too completely free.

Both of these are SQL Server Management Studio and Visual Studio plugins, so you can use them directly from within SSMS and VS.

Related questions

How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More
How do I perform an IF...THEN in an SQL SELECT?

How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product

Read More
How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More