What’s New in dbForge SQL Complete v5.8

Code Completion

Support for new context-based prompts:

  • ALTER MESSAGE TYPE
  • DROP MESSAGE TYPE
  • Prompt extension in SQLCMD Mode
  • Display a list of CHECK and DEFAULT constraints
  • Unwrap sp_executesql
  • OLE DB provider names are now suggested for the OPENROWSET and OPENQUERY operations
  • 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

Productivity

  • Jump between BEGIN/END
  • Jump between COLUMNS and VALUES in the INSERT statement
  • Execution warnings
  • CRUD generator
  • Run script on multiple databases
  • Execution notifications
  • Transaction reminder
  • Find in Results Grid
  • Copy Results Grid Headers
  • Grid Aggregates
  • Named Regions

Other improvements

Fixes and improvements on Document Session