dbForge SQL Complete is a useful add-in for Microsoft SQL Server Management Studio and Microsoft Visual Studio. Free and advanced paid editions of the SQL code formatter 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.
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.
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.
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.