Released: Jan 31, 2018

5.8.173 での更新項目

機能

• 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.