dbForge SQL Complete Express is a free intellisense add-in for SQL Server Management Studio. Designed to provide the fastest T-SQL query typing ever possible. Supports SQL Server 2000, 2005, 2008, 2011,2012, SQL Azure and SQL Server Compact edition. Added integration into Visual Studio 2008/2010/2012
Key features:
* Smart filtering: SQL Complete filters the suggestion list based on various criteria:
- first typed symbols,
- a whitespace,
- camel case,
- a square bracket.
* Quick Object Info: Essential information about a database object is shown in the pop-up window when the mouse cursor is over the identifier.
* List members: List members for major objects: database, schema, table, view, procedure, user and table-valued function (including CLR), built-in function, synonym, CLR aggregate;
* Parameter information for user-defined and built-in procedures/functions: When you are typing names of user-defined and built-in functions and procedures, SQL Complete displays their parameter information in a hint.
* SQL formatting: Produce clear and well-formatted code without worrying about all those indents, whitespaces, wrappings, line breaks, etc.
* Determining a database context: SQL Complete displays a list of database objects from the current database or schema even if their names are not specified in a query.
* «Execute current statement» feature
* Word autocomplete
* Context-sensitive suggestions of DML statements: INSERT, UPDATE and DELETE
* Manual refreshing of the suggestion list.
New features that come with version 4.0:
* New SQL formatting options editor
* Hierarchical list structure that simplifies working with SELECT and INSERT statements is also available
