The SQL code autocompletion and formatting tool for SQL Server Management Studio

dbForge SQL Complete is a useful add-in for SQL Server Management Studio and Visual Studio. Free and paid editions of the tool offer the powerful autocompletion and formatting of T-SQL code that replaces native Microsoft T-SQL Intellisense.

The tool can also be integrated into Visual Studio 2008 (Professional and Team System editions), Visual Studio 2010 (Professional, Premium, and Ultimate editions), Visual Studio 2012 and 2013 (Ultimate, Premium, Professional, Test Professional, Team Foundation Server editions).
Besides the extension of the List Members, Complete Word and Parameter Info features, SQL Complete also includes SQL Formatter.

Key Features:
-Context-based code completion
– Smart filtering to suggest relative keywords and objects
– Quick parameter info for functions
– Customizable SQL formatting
– Quick object info
– Context-based sorting of suggestions in the list
– Determining current database or schema
– Expanding a list of columns
– Suggesting conditions for JOIN statements
– Expanding INSERT, ALTER, and EXEC statements
– “Go to definition” for database objects
– Code snippets
– Document Outline window
– Highlight occurrences of an identifier
– Execute current statement
– Automatic alias generation
– Suggestions of T-SQL statements in procedures and functions
– Suggestions of other SQL statements
– IntelliSense for linked servers
– Semi-transparent view of the suggestion box