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.
Code completion in SQL Complete predicts not only keywords and object names, but also whole code fragments to simplify and accelerate your work. Intelligent suggestions with smart filtering make the code typing process really smooth and fast.
INSERT, ALTER, and EXEC statements will be expanded to the full code template on pressing the Tab key to avoid tedious typing.
Except the template, the type of column data will be generated in the comments.
For frequent repetitive usage of code fragments, SQL snippets feature can be used. The application shows available code templates in the dropdown prompt list, and any of them can be inserted into the code you are typing on pressing Tab. In Snippets Manager, predefined templates can be modified and new ones can be added.
SQL code can be automatically formatted using SQL Complete. The formatter can work either with available code or the code that is being typed. You don't need to pay that much attention to case, line breaks, whitespaces, indenting, wrapping, etc - the application will take care of them all for you.
Quick object information
The application gives you essential information on database objects while you are writing code. Get such information for tables, procedures, and other objects.
Parameter information prompts you with stored procedure and function parameters when writing call statements and relieves your memory.
With the Go to definition option, you can locate the needed object in the Object Explorer tree in a moment.
Document outline window, in its turn, allows navigating through large SQL documents. The window shows the structure of the current SQL document which can be easily synchronized with the code both ways.
Microsoft SQL Server Management Studio 2000, 2005 or 2008 installed
30 days trial period