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


GitHub Enterprise Server Adds Deployment Rollout Controls
11/03/2024

Version 3.12 of GitHub Enterprise Server, the self-hosted version of GitHub that organizations can install on their own servers, has been released with support for restricting deployment rollouts [ ... ]



Flox Releases Flox Hub
13/03/2024

Flox has announced that its Command Line Interface (CLI) and FloxHub are now generally available. The CLI is open source and FloxHub is free for anyone to use.


More News

 

raspberry pi books

 

Comments




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

 

Last Updated ( Monday, 17 August 2015 )