SQL Complete now has two editions: Express and Standard.
The Express edition provides basic functionality for working with DML statements. This edition is free.
The Standard edition provides extended functionality for working with DML and DDL statements, as well as with T-SQL and SQL formatting.
Working with large scripts
SQL Complete provides possibility to work with scripts of any size. In the first version the script size was limited to 150 000 symbols.
Expanded support for Transact-SQL statements
Suggesting conditions for JOIN statements
For JOIN statements, SQL Complete can suggest a full JOIN statement basing on foreign keys, or it can suggest conditions basing on column names.
Extended support for statements
SQL Complete fully supports such DDL statements as CREATE (for table, view, procedure, and function), and also EXEC, PRINT, and TRUNCATE TABLE.
When using the TRUNCATE TABLE statement in your query, a suggestion list containing databases, schemas, and tables will be displayed.
Suggesting methods for columns and variables
SQL Complete suggests methods for columns and variables of the varchar(max), nvarchar(max), varbinary(max), and xml data types.
Support for List Members and parameter info for XML and varchar(max) data type methods was added
Context-sensitive suggesting of collations, data types, XML schema collections, and languages
SQL Complete can suggest collations, XML schema collections, languages and data types when writing SQL statements.
For example, when creating columns in a table, SQL Complete will suggest possible data types for it, including user-defined types.
Sorting keywords by relevance
SQL Complete can sort keywords by relevance in the suggestion list.
Qualify column name on completion
In SELECT statements, SQL Complete can insert column names with the name of table, schema, and database it belongs to.
Now you don’t have to type the object name each time. SQL Complete can generate a table name only without prefix containing schema name, table name with prefix containing schema name, or table name with prefix containing database and schema names.
Expanding list of columns in SELECT statement
In SQL Complete, the * symbol in SELECT list can be replaced by the list of objects (tables, views, etc.) specified in the FROM list on pressing the Tab key.
Automatic alias generation in SELECT statements
SQL Complete can generate an alias for each table object (table, view, stored procedure, function, synonym, sub-query) in the FROM list of your SQL document automatically.
SQL Complete performance was greatly improved in the new version.