Extended SQL Complete Comes With Rich Autocomplete Features, and Keeps Free Intellisense for SQL Server People!
We are glad to announce the new extended version of dbForge SQL Complete 2.0 that will bring SQL Server database developers and DBAs around the world new speed in writing SQL statements to increase efficiency and code quality.
Close collaboration with SQL Server database developers and DBAs resulted in the following Technical Advancements of dbForge SQL Complete 2.0:
¡¤ Extended support for statements
dbForge SQL Complete fully supports such statements as CREATE (for table, view, procedure, and function), EXEC, PRINT, and TRUNCATE TABLE. When TRUNCATE TABLE statement is used in a query, the tool suggests a list of databases, schemas, and tables.
¡¤ Suggesting conditions for JOIN statements
dbForge SQL Complete can suggest a full statement based on foreign keys, or it can prompt conditions based on column names.
¡¤ Automatic alias generation
The tool can generate an alias for each table object (table, view, stored procedure, function, synonym) in the FROM list of SQL document automatically.
¡¤ Expanded support for Transact-SQL statements
SQL Complete supports: DECLARE statements for local variables, cursor variables, and table definitions; cursors (declared with the help of DECLARE CURSOR statements) in OPEN, CLOSE, DEALLOCATE statements; 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 collations, data types, XML schema collections, and languages
dbForge SQL Complete can suggest collations, XML schema collections, languages and data types when writing SQL statements. For example, when creating columns in a table, dbForge SQL Complete will suggest possible data types for it, including user-defined types.
Product Editions to Offer Rich Functionality and Keep Free IntelliSense
dbForge SQL Complete now comes in two editions to better cater for the needs of SQL database developers and DBAs. They can select a free Express edition to get free intellisense, or the Standard edition, which is available for a price of $49.95, to have surpassing sql code completion and formatting.
Learn more!
Try now the dbForge SQL Complete 2.00 !
With Best Wishes,
The Devart Team