SQL Complete Is Rushing Forward with Users' Help
February 28, 2011
Today Devart unveiled the new version of dbForge
SQL Complete, a smart code completion add-in for Microsoft SQL Server Management
Studio. As the first version produced a stream of grateful feedback, the Devart
team was encouraged to deliver SQL Complete 2.50, equipped with much-anticipated
features to provide breathtaking speed and efficiency during SQL code typing.
After only a month since version 2.0 release Devart delivers enhanced code completion
features that make up forefront code intellisense providing unique experiences in
The Standard edition of SQL Complete now incorporates these major advancements:
Quick object info
Essential information about a database object is shown in the popup window when
the mouse cursor is over the identifier. For tables users can see column names with
data types, additional column properties (e.g., not null and identify attributes),
primary, unique, and foreign keys. For other objects, the quick info includes object
type and an available user description.
* Express Edition offers partial support of the quick object info feature
Expand INSERT statement feature
This feature saves much time for users as it allows them to type just a table name
in INSERT statement and expand the statement to the full template by pressing the
Export/Import settings wizard
The wizard serves for quick and handy export of the tool's setting to a file and
future usage of this file to import settings.
Context-sensitive code completion for common table expressions (CTE)
CTE significantly speeds up expression typing by prompting relevant suggestions.
Improved logic for JOIN clause suggestions
Now duplicate conditions are removed from the suggestion list to enable users quickly
select a required item from the list.
Delivering on the promise to provide free tools for SQL Server community, the Devart
team continues supporting and upgrading the free Express edition of SQL Complete.
Now the free edition, as well as the Standard one, boasts of owning the following
Improved SQL Formatter
Delivers more formatting freedom for users by allowing them to:
- put commas at the beginning of lines in lists, e.g., in SELECT lists;
- use additional options to format CASE expressions and logical operands;
- use the option to add or remove a space between a function name and an opening
bracket of the argument list.
Reset Page Defaults button added
Users can find the button in the Options dialog and use it to reset setting on a
required options page in one click.
SQL Complete 2.50 puts the speediest and most pleasant code typing into hands of
developers, web masters, DBAs, and anyone who makes his or her first steps in SQL
With the growing popularity of SQL Server, SQL Complete becomes the necessity rather
than a gizmo, and not only removes slightest hurdles and builds smooth code autocomplete,
but also grants users more control over SQL code typing and pleases with new experiences.
Consumers can give the updated dbForge SQL Complete a test drive by downloading
the free Express edition or the 30-day trial Standard edition at the product
download page. SQL Complete's Standard edition is available for an estimated
retail price of $49.95.
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.