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


JetBrains Announces Kotlin Goodies
17/11/2021

JetBrains has announced several new tools and projects designed to add to and improve the Kotlin ecosystem. The announcements were made at JetBrain's Kotlin 2021 Premier event, and include a new faste [ ... ]



The Third Age Of AI - Megatron-Turing NLG
03/11/2021

We seem to be moving through a third revolution in AI and it is advancing without too much notice. Part of the reason is that it is difficult to know for sure where the revolution is going.


More News

 

square

 



 

Comments




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

 

Last Updated ( Monday, 17 August 2015 )