What’s New in dbForge SQL Complete v2.0

Editions

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

  • DECLARE statements for local variables, cursor variables, and table definitions;
  • statements for working with cursors such as DECLARE, OPEN, CLOSE, DEALLOCATE;
  • context for such control-of-flow and T-SQL statements as BEGIN…END, GOTO, IF…ELSE, RETURN, BREAK, CONTINUE, WHILE, WAITFOR, TRY…CATCH, CASE, RAISERROR.

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.

Performance improvements

SQL Complete performance was greatly improved in the new version.