dbForge SQL Complete 5.0
Written by Kay Ewbank   
Monday, 17 August 2015

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

 SQLComp

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.

 

devart2

 

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.

 

Banner


Java Version 23 Released
30/09/2024

It was in April 2024 that we had Java 22. Now after just 6 months there's version 23, which is a STS release with lots of features in preview status.



A Turing Machine In LEGO
06/10/2024

A Turing Machine is one of those abstract ideas that is much easier to undertand if you can see it working. Now there's a proposal on the LEGO Ideas site for a Working Turing Machine. Lend it your sup [ ... ]


More News

 

kotlin book

 

Comments




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

 

Last Updated ( Monday, 17 August 2015 )