Released: May 22, 2019

9.5.4 での更新項目

Updates in SQL Prompt 9.5.4

• SP-6941 : Fixed an issue where formatting places ORDER BY clause on the next line when it is within WITHIN GROUP
• SP-7232 : Add suggestion support for some missing system functions: CONNECTIONPROPERTY, CURRENT_REQUEST_ID, CURRENT_TRANSACTION_ID and ORIGINAL_DB_NAME.
• SP-7583 : Fixed an issue where formatting ALTER INDEX within an ALTER TABLE statement would throw an error.
• SP-7596 : SQL Prompt now supports `TEMPORAL_HISTORY_RETENTION` and `HISTORY_RETENTION_PERIOD` keywords when using SQL Server 2017.
• SP-7591 : Fixed an issue where formatting a script that contains sqlcmd instructions would sometimes cause lines to be duplicated.
• SP-7598 : Now suggests `TableTemporalType` as a parameter option in OBJECTPROPERTY and OBJECTPROPERTYEX functions.
• SP-7605 : Fixed an issue with installing SQL Prompt into both Visual Studio 2017 and 2019 at the same time.
• SP-7619 : Fixed bug that could cause the background loading of database information to fail (leading to incomplete suggestions) when attempting to retrieve the default schema name.
• SP-7620 : When checking for updates, the popup window no longer shows the install and download options if running the latest.
• SP-7622 : Fixed description of BP024 that was incorrectly mentioning that sql_variant was not supported in Azure SQL Databases.