SQL Complete 4.0 with Superior SQL Formatter is Here!
December 13, 2012
Devart Team is glad to announce the new release of SQL Complete v4.0. We have analyzed multiple user suggestions and completely re-designed SQL formatter in order to ensure supreme settings flexibility and company coding style standards unification. Also, we have improved code completion usability and expanded SQL code refactoring features.
Brand new SQL Formatter component
We have revised and improved this essential component. Pivotal new formatting features include:
Formatting profile introduced
Formatting preferences stored in an individual file
Personalize SQL formatting settings and save them in a single .xml file for convenient handling.
Multiple formatting profiles and profile import supported
Activate whichever profile that suits your needs best, import and export profiles.
Single-profile for multiple workstations
Share your settings with colleagues to meet the company's code-formatting standards.
New formatting options editor
Option quick search
Use quick search filter when editing formatting settings.
Sample code displays formatting according to current formatting settings
Instant preview for introduced changes.
Editable sample code formatting preview
Insert a piece of your own code into the preview field to see the way it looks like with applied SQL Complete formatting settings.
Enhanced formatting settings
Any SQL-statement formatting can now be adjusted independently and more precisely
Get unique formatting for each statement type.
Formatting settings for sub-queries added
Sub-queries can now be formatted separately from the queries and other query types' sub-queries.
Word recognition for different identifier cases
Switch between UPPER, lower or CamelCase - individual words will still be recognized.
- Independent built-in datatype case formatting settings
New SQL code refactoring features
With the new version, we are taking the product to a new level.
Code and database identifier case synchronization
If your database identifiers were created according to certain adopted rules, then you will have no problem transforming SQL script identifier case to that of the database.
Stored procedure call expansion
It takes a single click to transform EXECUTE statement into a code block containing the procedure body. Execution logic is preserved, which allows easier code debugging.
New code completion features
- Table order in ON condition of suggested JOIN clause can now be reversed. Behavior can be toggled in the options menu
- Inserted columns in SELECTs are now automatically qualified with a table alias. Behavior can be toggled in the options menu
- Functions are now inserted from suggestion list with braces
- 'Refresh Local Cache' and 'Refresh Suggestions' commands now use the same shortcut
- ALTER TABLE statement now has context-sensitive identifier suggestion
- 'Run Current Statement' command usability slightly improved
- The Express edition has been enhanced with code completion for temporary tables
Integration with SSDT in Visual Studio 2010/2012
Last but not least piece of news: developers that have employed SQL Server Data Tools in Visual Studio 2010 and 2012 can now also benefit from using SQL Editor with SQL Complete features.
Give the new version dbForge SQL Complete a test drive by downloading the 30-day trial Standard edition at the product download page. SQL Complete's Standard edition is available for an estimated retail price of $119.95.
Get more than SSMS IntelliSense has to offer for free with the Express edition.
Provide feedback at the dbForge SQL Complete feedback page. The Devart team is looking forward to receiving your comments and suggestions.