dbForge SQL Complete 5.8.173

dbForge SQL Complete 5.8.173
Run scripts on multiple databases.

News

Feature Release

February 07, 2018 - 15:35
dbForge SQL Complete 5.8.173
Run scripts on multiple databases.
  • Code Completion Features
    • ALTER MESSAGE TYPE
    • DROP MESSAGE TYPE
    • Suggestion in SQLCMD Mode extended
    • Display a list of CHECK and DEFAULT constraints
    • Unwrap sp_executesql
    • OLE DB provider names are now suggested for OPENROWSET and OPENQUERY
    • XML methods suggestion XQuery
    • CREATE TYPE .. AS TABLE
    • CREATE TYPE .. FROM
    • SET DATEFORMAT
    • SEND ON CONVERSATION
    • CREATE QUEUE
    • CREATE AGGREGATE
    • CREATE ASSEMBLY FROM
    • DBCC CLONEDATABASE
  • Jump between BEGIN/END - Navigate through the whole block while matching BEGIN/END statements.
  • Jump between COLUMNS and VALUES in INSERT statements - Helps you easily find the corresponding values of specified columns in INSERT statements. The command will highlight the matching column and value.
  • Execution warnings - Shows a warning message that may cause data loss when executing UPDATE or DELETE statements without a WHERE clause, as well as TRUNCATE.
  • CRUD generator - Generates a result script for SELECT, INSERT, UPDATE, and DELETE statements to a new SQL document.
  • Run scripts on multiple databases - Executes a script on several databases via the connection you choose.
  • Execution notifications - When a query execution is completed, a notification that includes name of document and duration is diplayed.
  • Transaction reminder - Alerts users that a transaction has not been completed.
  • Find in Results Grid - Highlights all matches either by case, or whole words, or regular expressions in the results grid.
  • Copy Results Grid Headers - Copy selected column names and/or types to CSV, XML, HTML, and JSON data formats.
  • Grid Aggregates - Selecting two or more rows in one column automatically opens an aggregate grid that displays calculations on the SSMS status bar.
  • Named Regions - Parse named and unnamed regions automatically, as well as wrap and unwrap regions.
  • Find Invalid Objects - Search for objects that refer to other, nonexistent objects in the database.
  • Formatting Profile Quick Select - Quickly switch between active formatting profiles.
Classification: