SQL Complete v5.7 release notes

SQL Server Support

  • SQL Server 2016 Service Pack 1 (SP1) new syntax support
  • SQL Server 2017 CTP2 new syntax support
  • Azure SQL Data Warehouse connectivity support

Code Completion

  • Highlight of matching columns in the INSERT statement
  • Exclusion of database elements from the Completion List prompt
  • Option to exclude schema in the ON condition of the JOIN statement
  • Option to connect/disconnect when describing/pre-describing objects of the same database
  • Query navigation
  • CASE END pair highlighting
  • Generation of the CREATE/ALTER script for server objects with the object decryption option
  • Extended suggestion in the PIVOT/UNPIVOT queries
  • Extended support for CTE
  • Prompt and QI of variables in named transactions
  • CREATE OR ALTER statement support
  • Display of the estimated row count for tables

Extended Code Completion support for:

  • Object prompting in:
    • CREATE OR ALTER statements
    • DROP ROUTE
    • ALTER ROUTE
    • DROP SERVICE
    • ALTER SERVICE
    • DROP RULE
    • DROP CONTRACT
    • ALTER QUEUE
    • CREATE PARTITION FUNCTION
  • Syntax support for:
    • CREATE ( ALTER, DROP ) COLUMN ENCRYPTION KEY
    • ALTER EXTERNAL DATA SOURCE
    • ALTER EXTERNAL RESOURCE POOL
    • CREATE EXTERNAL TABLE AS SELECT
    • CREATE REMOTE TABLE AS SELECT
    • STRING_AGG
    • CONCAT_WS
    • TRANSLATE
    • TRIM
    • BULK INSERT and OPENROWSET ( BULK… )
    • BLOB_STORAGE option of EXTERNAL DATA SOURCE
    • DBCC CLONEDATABASE
    • ALTER ANY MASK
    • BACKUP (RESTORE) DATABASE TO URL
    • ALLOW_ENCRYPTED_VALUE_MODIFICATIONS

Other improvements

  • Tab coloring
  • Enabling/disabling SQL Complete from the menu
  • Generate Script As from the SSMS shortcut menu

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge SQL Complete for SQL Server.
All Features

All features

Get acquainted with the rich features and capabilities of the SQL Complete in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the SQL Complete for your business, request a demo to see it in action.
Ready to start using dbForge SQL Complete for SQL Server?
Download a free 30-day trial