Catalog.CodeProject.com

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

Key features:
 
Key features:
* Name suggestions for all SQL Server objects
* Smart filtering in the suggestion list
* Context-sensitive suggestion of keywords
* Database context detection
* Context-sensitive object suggestions for SELECT, DML, DROP, EXEC, SET, and USE statements
* Parameter information for functions
* Quick object information in a pop-up window
* Customizable SQL formatting
* Execute current statement in a script
* Semi-transparent view of the suggestion box
* Name suggestions for objects on linked servers
* Column picker for quick list building
* JOIN clause auto generation
* Wildcard expansion
* INSERT, EXEC, and ALTER statements expansion
* Auto-generation of table aliases
* Code completion for common table expressions (CTE)
* Context-sensitive object suggestions for T-SQL code, DDL, and security statements
* SQL Snippets for reusable code
* Document Outline window for showing script structure
* "Go to definition" for database objects
* Adjust keyword case on typing
* Intellisense in SQLCMD mode
* Highlight occurrences of an identifier
* Sorting suggested keywords by relevance
* Export/Import Settings Wizard
 
Compatibility
 
Microsoft SQL Server:
* SQL Server 2012
* SQL Server 2008, 2008R2 (including Express)
* SQL Server 2005 (including Express)
* SQL Server 2000
* SQL Azure
* SQL Server Compact
 
Microsoft SQL Server Management Studio:
* SSMS 2012
* SSMS 2008, 2008R2 (including Express)
* SSMS 2005 (including Express)
 
Microsoft Visual Studio:
* Visual Studio 2010: Professional, Premium, and Ultimate editions
* Visual Studio 2008: Professional and Team System editions