dbForge SQL Complete

Meet dbForge SQL Complete functionality in SQL Server Management Studio 2016

July 20, 2016

Today, we are very pleased to announce the new version of dbForge SQL Complete v5.5 with support for SQL Server 2016 and SQL Server Management Studio 2016.
If you already use the tool, just "Check for Updates” in dbForge SQL Complete to upgrade to the new version. The new features and enhancements increase the power and productivity of database specialists who design, develop, and maintain databases and data storage systems.

What’s new?

Expanded suggestions support for SQL Server 2016 grammar

The latest release of SQL Server introduced a bunch of new features and new SQL syntax. The tool now offers code suggestions for the new syntax when you are developing in SSMS or Visual Studio.

pic

New formatter options and profiles

pic

There are three predefined formatting profiles available. You may use them to save some time on customization process.

Suggestions in CROSS / OUTER APPLY constructions

Now suggestions are available in queries that include a correlated subquery.

pic

Execute statements to cursor position

pic

One simple command to execute all the SQL code located above the current cursor position. To add more convenience to stored procedure debugging and designing related queries.

Compound phrase suggestions

The suggestion engine prompts key phrases along with keywords. For instance, instead of CREATE XML you will get CREATE XML SCHEMA COLLECTION or CREATE XML INDEX.

pic

Object and schema suggestions while writing cross-database queries

The suggestion list prompts database objects as well as schemas while writing cross-database queries.

Get it Now

Download a trial version of dbForge SQL Complete now and evaluate its benefits for free during a 30-day trial period.

Join our forum to participate in discussions around the Devart software, including dbForge SQL Complete. Find answers to your technical questions and other valuable information on dbForge SQL Complete and other products for SQL Server.