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, SQL Azure and SQL Server Compact edition. Added integration into Visual Studio 2008 and 2010.
Key features:
Smart filtering:
SQL Complete filters the suggestion list based on various criteria:
Quick Object Info:
Essential information about a database object is shown in the popup 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.