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.