Advanced SQL IntelliSense is Now Available for Any SQL Server
February 2, 2012
Devart Team is glad to announce the new release of
SQL Complete v3.5. It includes support of all versions and editions of SQL
Server, column picker, extended T-SQL syntax support and many other features.
In the new version, we've made a huge effort to improve usability of our Intellisense
and paid a lot of attention to the application quality in general. Together with
the new features, meet new look of the suggestion list and new level of the usability
of our application!
Support of SQL Server 2012 and SQL Server Compact Edition
As support for the new version of SQL Server was introduced together with full support
for Compact Edition, developers got an opportunity to use the advanced SQL Intellisense
functionality with any server version and edition, starting with SQL Server 2000
and up to SQL Azure.
Column picker feature
New functionality will make it possible to create SELECT and INSERT queries, as
it allows defining column lists for selecting, grouping, sorting and inserting without
typing any code at all. The suggestion list appearance was changed - now it supports
hierarchical view for table columns and shows information about data type.
Intellisense in SQLCMD mode
Scripts that are executed with the help of the command line utility, are usually
parameterized. But often it is the reason of the fact that ability to show correct
suggestions for objects is lost, because database or schema name can be a variable.
Now SQL Complete solves this problem. Values of variables are taken from the text
of the document and object suggestions work as with an ordinary SQL script.
Automatic formatting of keywords on typing
Keywords are formatted according to the option settings. This will help to avoid
appearance of keywords written in different registry, when part of them was inserted
from the suggestion list and part was typed manually.
Extended and revised SQL Snippets
We've revised existing code templates, added new ones, and changed the behavior
of the suggestion list on selecting a template. This will allow choosing the needed
template as quickly as possible and reducing time needed for typing recurring code
constructions. Also keep in mind that users can create their own SQL snippets with
the help of the special editor.
Extended T-SQL syntax support
Context-sensitive prompt of objects in the MERGE statement and a number of SQL Server
2012 T-SQL construction is supported.
SQL formatting improved
Formatting of procedure and function code, CASE statements, comments, and column
list inserted on wildcard expansion is improved.
Express edition feature set extended
The free Express edition of our product is also improved. Now it supports SQL Server
2012 and SQL Server Compact Edition. Besides, information on columns is expanded,
and hierarchical list structure that simplifies working with SELECT and INSERT statements
is also available in the free edition.
Consumers can give the updated dbForge SQL Complete a test drive by downloading
the 30-day trial Standard edition at the product
download page. SQL Complete's Standard edition is available for a retail
price of $99.95. Volume discounts apply.
If you don't need advanced code completion features but want to get more than SSMS
IntelliSense can give, you are welcome to try free Express edition.
To leave feedback, users can go to the
dbForge SQL Complete feedback page. The Devart team is looking forward to
receiving any comments and suggestions.