Rich set of useful features Comes also in a free version Can be integrated into SSMS as well as Visual Studio
Cons
None
DbForge SQL Complete
Price: $
Want to increase your efficiency when creating SQL statements? With dbForge SQL Complete add-in for SSMS and Visual Studio, you can greatly streamline your SQL development. Add-in can be integrated into SSMS 2012 and later, and Visual Studio 2012 and later.
Tools' main advantage lies in its ability to provide autocomplete functionality when writing SQL statements. Besides that, it also supports the formatting of SQL code, and to make the code more readable, you can make use of its refactoring functionality as well.
Its functionality doesn't end with that. In addition to the three functionalities mentioned above, the tool also includes snippets functionality, warnings when executing SQL statements, the ability to assign color to each opened tab of the host software, and many more.
It was created as an upgrade or replacement to a default Intellisense functionality provided by Microsoft and can be downloaded in two versions, a paid Standard version and a free Express version. You should note that a free version lacks a considerable amount of features compared to the paid version.
When installing the add-in, a new menu called SQL Complete is created within the host software. Here you can access SQL Formatter Wizard to automatically format a set of files or directories. Here you can also manage snippets, edit procedure templates, view statement execution history, and more.
In conclusion, dbForge SQL Complete is a tool for SQL developers and other programmers, to help them with creating SQL queries faster and easier. It supports SSMS and Visual Studio and comes also in a free version which is limited to only basic features.
Reviewed by Tony Hill (editor rating 4.5 out of 5 stars) Sooftware editor's pick