The latest version of dbForge SQL Complete has been released with SQL refactoring and code highlighting.

dbForge SQL Complete is an IntelliSense add-in for SQL Server Management Studio and Visual Studio. It supports all version of SQL Server, and the new version is available in SSDT SQL Server projects. It lets you set formatting options so the code is formatted to your needs and preferences, and you can customize code style settings and share them with other team members.

Version 5.0 adds support for expanding Update statements to full code templates when you press the Tab key. You get the full template; a Column data type with NOT NULL and ROWGUID properties; a template for inserting time (for datetime data type); and a DEFAULT clause (if a default value is created for a table).

The new version also has new code templates for Begin Transaction and Rollback Transaction statements. You can insert snippets into the code you are typing by pressing Tab or Enter. There’s a Snippets Manager where you can edit the code templates, and you can also add parameters to a code template.

The code highlighting now highlights both the opening and closing code elements to visually define separate code blocks and determine mismatched or misspelled paired code elements. Custom alias mapping means you can assign individual names to tables, views, table-valued functions, or synonyms referenced to in an SQL document. You can assign distinct aliases for same-named objects and vice versa, and you can exclude a portion from a generated alias. You can also specify a prefix to be ignored or added to an alias.

The new SQL Refactoring means you can rename all occurrences of variable names and object names without breaking dependencies. The other improvement to the new version is automatic semicolon Insertion, so you can automatically insert missing semicolons after each statement in a query.

This introductory Tutorial gives an overview of its main features and examples of its patterns usage:

dbForge SQL Complete comes in both free and paid editions.

Comments

Make a Comment or View Existing Comments Using Disqus

or email your comment to: comments@i-programmer.info