Today Devart unveiled the new version of dbForge SQL Complete, a smart code completion add-in for Microsoft SQL Server Management Studio. As the first version produced a stream of grateful feedback, the Devart team was encouraged to deliver SQL Complete 2.50, equipped with much-anticipated features to provide breathtaking speed and efficiency during SQL code typing.

After only a month since version 2.0 release Devart delivers enhanced code completion features that make up forefront code intellisense providing unique experiences in query typing.

The Standard edition of SQL Complete now incorporates these major advancements:

• Quick object info

Essential information about a database object is shown in the popup window when the mouse cursor is over the identifier. For tables users can see column names with data types, additional column properties (e.g., not null and identify attributes), primary, unique, and foreign keys. For other objects, the quick info includes object type and an available user description.

Express Edition offers partial support of the quick object info feature.

• Expand INSERT statement feature

This feature saves much time for users as it allows them to type just a table name in INSERT statement and expand the statement to the full template by pressing the Tab key.

• Export/Import settings wizard

The wizard serves for quick and handy export of the tool’s setting to a file and future usage of this file to import settings.

• Context-sensitive code completion for common table expressions (CTE)

CTE significantly speeds up expression typing by prompting relevant suggestions.

• Improved logic for JOIN clause suggestions

Now duplicate conditions are removed from the suggestion list to enable users quickly select a required item from the list.

Delivering on the promise to provide free tools for SQL Server community, the Devart team continues supporting and upgrading the free Express edition of SQL Complete. Now the free edition, as well as the Standard one, boasts of owning the following updates:

•nImproved SQL Formatter

Delivers more formatting freedom for users by allowing them to:

   • put commas at the beginning of lines in lists, e.g., in SELECT lists;

   • use additional options to format CASE expressions and logical operands;

   • use the option to add or remove a space between a function name and an opening bracket of the argument list.

• Reset Page Defaults button added

Users can find the button in the Options dialog and use it to reset setting on a required options page in one click.

SQL Complete 2.50 puts the speediest and most pleasant code typing into hands of developers, web masters, DBAs, and anyone who makes his or her first steps in SQL code writing.

With the growing popularity of SQL Server, SQL Complete becomes the necessity rather than a gizmo, and not only removes slightest hurdles and builds smooth code auto-complete, but also grants users more control over SQL code typing and pleases with new experiences.