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.
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.
Scripts that are executed with the help of the command line utility are usually parametrized. Often the ability to show correct suggestions for objects is lost, because a 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.
Keywords, built-in functions, variables, parameters, and object identifiers are formatted according to the options settings. This will help to avoid appearance of keywords, built-in functions, etc. written in different registry, when part of them was inserted from the suggestion list and part was typed manually.
Existing code templates are revised, new ones are added, and the behavior of the suggestion list on selecting a template is changed. 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.
Context-sensitive prompt of objects in the MERGE statement and a number of SQL Server 2012 T-SQL construction is supported.
Formatting of procedure and function code, CASE statements, comments, and column list inserted on wildcard expansion is improved.
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.