New SQL Complete includes not only an enriched SQL formatter, but also an improved code completion usability, expanded SQL code refactoring features and smoothly performing IntelliSense.
Key improvements of the SQL Complete 4.0:
Brand new SQL Formatter component
Pivotal new formatting features include:
Formatting profile introduced:
Formatting preferences stored in an individual file
Multiple formatting profiles and profile import supported
Single-profile for multiple workstations
New formatting options editor
Option quick search
Sample code displays formatting according to current formatting settings
Editable sample code formatting preview
Enhanced formatting settings
Any SQL-statement formatting can now be adjusted independently and more precisely
Formatting settings for sub-queries added
Word recognition for different identifier cases
Independent built-in datatype case formatting settings
New SQL code refactoring features
Code and database identifier case synchronization
If the database identifiers were created according to certain adopted rules, then there will be 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 for easier code debugging.
New code completion features
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.
Availability
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.