Added sql_variant type support, including SQL_VARIANT_PROPERTY function
Added IS [NOT] DISTINCT FROM predicate support
Added @@SERVERNAME and @@VERSION global variables
Added SERVERPROPERTY function support
Added USE_LEGACY_UPDATE_MESSAGES query hint to use legacy update messages Assign, SetState, SetParentBusinessUnit and SetBusinessEquipment
Subquery fixes:
Only include requested columns from CROSS APPLY and query-defined tables
Performance improvements for uncorrelated scalar subqueries
Only retrieve minimal rows for scalar subqueries
Fixed use of nested IN and EXISTS subqueries
Fixed use of table-valued function with alias
Fixed JSON_VALUE function with embedded null literals
Fixed bulk DML operations that require non-standard requests
Do not use merge joins for data types with different sort ordering
Fixed filtering and sorting on non-lowercase attributes
Fixed executing messages with OptionSetValue parameters
Improved error reporting on batch DML statements
XTB
Updated minimum XTB version
Improved plugin load logic to avoid version problems with dependencies
Added autocomplete for collation names and variable names
Fixed cross-threading error when showing warning messages
Preserve tool window locations
Improved display of string values containing line breaks and tabs
ADS
Added autocomplete for collation names and variable names
Engine
Added
sql_variant
type support, includingSQL_VARIANT_PROPERTY
function AddedIS [NOT] DISTINCT FROM
predicate support Added@@SERVERNAME
and@@VERSION
global variables AddedSERVERPROPERTY
function support AddedUSE_LEGACY_UPDATE_MESSAGES
query hint to use legacy update messagesAssign
,SetState
,SetParentBusinessUnit
andSetBusinessEquipment
Subquery fixes:
CROSS APPLY
and query-defined tablesIN
andEXISTS
subqueriesFixed use of table-valued function with alias Fixed
JSON_VALUE
function with embedded null literals Fixed bulk DML operations that require non-standard requests Do not use merge joins for data types with different sort ordering Fixed filtering and sorting on non-lowercase attributes Fixed executing messages with OptionSetValue parameters Improved error reporting on batch DML statementsXTB
Updated minimum XTB version Improved plugin load logic to avoid version problems with dependencies Added autocomplete for collation names and variable names Fixed cross-threading error when showing warning messages Preserve tool window locations Improved display of string values containing line breaks and tabs
ADS
Added autocomplete for collation names and variable names