dbForge SQL Complete 3.10

dbForge SQL Complete is a useful add-in for SQL Server Management Studio. It offers powerful autocompletion and formatting of T-SQL code features, supports SQL Server 2000, 2005, 2008, 2011, SQL Azure and SQL Server Compact edition and can be integrated into Visual Studio 2008 and 2010.

Key features:

* Context-based code completion
dbForge SQL Complete has a feature to offer code completion lists based on context instead of simply listing object attributes and methods.

* Code Snippets
This feature makes it easy and convenient to use fragments of code over and over.

* Suggesting conditions for JOIN statements
dbForge SQL Complete can suggest a full statement based on foreign keys, or it can prompt conditions based on column names.

* Expanding INSERT, ALTER, and EXEC statements
You can expand INSERT, ALTER, and EXEC statements to the full template on pressing the Tab key.

* Customizable SQL formatting
Produce clear and well-formatted code without worrying about indents, whitespaces, wrappings, line breaks, etc.

* Document Outline window
The Document Outline window shows the structure of the current document.

* Quick object info
Essential information about a database object is shown in the popup window when the mouse cursor is over the identifier.

* Parameter info for procedures and functions
When you type names of user-defined and built-in functions and procedures, dbForge SQL Complete will display their parameter information in a hint.

* "Execute current statement" feature
Users can execute the current SQL statement in the document using the hot key.

* Linked servers support
Users can type their queries with the kind of IntelliSense they are accustomed to even when using all advantages of linked servers configuration.

* SQL statements support is extended
Support for GRANT, REVOKE, DENY, ENABLE/DISABLE TRIGGER, and ALTER SCHEMA statements.

* New Highlight Occurrences option
Allows to turn highlighting on and off.