dbForge Adds SQL 2016 Support
Written by Kay Ewbank   
Tuesday, 23 August 2016

A new version of dbForge Query Builder for SQL Server has been released with support for SQL Server 2016.

The tool lets you build SQL queries using a visual query building interface rather than by writing SQL code. The query builder lets you drag and drop tables onto the query diagram, set joins and select columns.

dbforgequery

Alongside the query design, Query Builder has visual query profiling, so you can show results from Explain, Show Profile, and Show Status profiling in the UI. You can also select results for two query executions and see what the differences are.

The other option offered by Query Builder is SQL code 'beautification'. This lets you modify existing code or write new code that conforms to standards for the formatting using customizable profiles. There are three new predefined formatting profiles in the new version to improve this aspect of the tool. 

The main change to the new version is the support for SQL Server 2016, but there are other improvements, starting with improved query suggestions. The suggestions appear more quickly, you can get suggestions when creating queries that include a correlated subquery, and the designer will make suggestions of objects that are available in CROSS/OUTER APPLY statements. The query designer will also make suggestions  that include compound phrases such as LEFT HASH JOIN or LEFT MERGE JOIN as well as simpler choices.

dbforgecompound phrases

 

The Data Grid has also been improved. The column header now shows data type information, and you can use the 'Generate Script As' feature in the Data Grid, as well as for multiple objects in Database Explorer. This last improvement means you can select several database objects in Database Exploer and generate scripts on the basis of what you've selected.

dbforgequery 

 

More Information

Query Builder Site

What's New In Query Builder

Related Articles

dbForge SQL Complete 5.0

Mycli 1.0

SQL Prompt - An Add-In To Aid Productivity

 

 

To be informed about new articles on I Programmer, sign up for our weekly newsletter,subscribe to the RSS feed and follow us on, Twitter, FacebookGoogle+ or Linkedin

 

Banner


Foojay - All About Java and the OpenJDK
02/11/2020

Tracking the OpenJDK is not an easy feat. It evolves rapidly under a release cycle of a new version every 6 months, hence there's hoards of new features, changes and bug fixes.This is where foojay ste [ ... ]



An Introduction to Neo4j
03/11/2020

Learn about Neo4j and Cypher in less than a day with a free course that  introduces you to graph databases and how to use the Cypher graph language to query and update a Neo4j database.


More News

 

square

 



 

Comments




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

Last Updated ( Tuesday, 23 August 2016 )