SQL Complete v5.8 release notes

Last modified: April 9, 2025

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