Released: Mar 28, 2024

10.14.11.7894 での更新項目

機能

• Added support for Microsoft SQL Server Management Studio (SSMS) 20.

Released: Mar 14, 2024

10.14.10.7538 での更新項目

不具合の修正

• Fixed exporting results to Microsoft Excel format.
• Fixed "Could not load file or assembly System.Memory" exception, occurring when using SqlPrompt.Format.CommandLine.exe from FormatCommandLine.zip.

Released: Feb 29, 2024

10.14.9.7331 での更新項目

機能

• Add refactoring for converting sp_executesql expressions to SQL.
• Added formatting for EXTERNAL TABLE, EXTERNAL DATA SOURCE, EXTERNAL FILE FORMAT.
• Added formatting for WINDOW clause.

不具合の修正

• Fixed an issue where casing wouldn't be applied to a built-in function after cross applying a statement with a user defined XML function.
• Fixed an issue where "Qualify Object Names" would add incorrect qualifier for temporary table columns in the FOR UPDATE OF clause.

Released: Feb 8, 2024

10.14.8.6563 での更新項目

機能

• Added suggestions in LAG, LEAD and formatting in LAG, LEAD, FIRST/LAST_VALUE for RESPECT/IGNORE NULLS.

Released: Jan 31, 2024

10.14.7.6275 での更新項目

不具合の修正

• Fixed an issue where FOR item in PIVOT clause would not collapse properly when collapse if short parentheses option was set.
• Fixed an issue where create script preview for table wouldn't show data types precision if default value was used.

Released: Jan 24, 2024

10.14.6.5992 での更新項目

機能

• Added intellisense support to EXTENDED EVENTS syntax.

不具合の修正

• Fixed an issue where formatting query with RESTORE statement wouldn't properly format URL clause.
• Fixed an issue which caused single-line comments to occasionally not align.
• Fixed an issue where indentation was missing after WHILE statement in formatted script.
• Fixed connection issues with Microsoft Entra MFA for Visual Studio 2019/2022.

Released: Jan 4, 2024

10.14.5.5385 での更新項目

機能

• Added the option to disable formatting for groups of single-line comments.

不具合の修正

• Fixed formatting for multiline comments.
• Fixed an issue where code formatter crashed with double angle brackets present in a script.
• Fixed an issue where new lines would be added after comment instead of before one.
• Fixed an issue where formatting would fail for OPTION (ORDER GROUP) query hint.

Released: Dec 7, 2023

10.14.4.4865 での更新項目

不具合の修正

• Fixed an issue where Pre/Post script window in SQL Source Control would cause SQL History to crash.
• Fixed missing newline before INTERSECT and EXCEPT operators.
• Fixed an issue where unformatting would add unnecessary spaces.

Released: Nov 29, 2023

10.14.3.4664 での更新項目

不具合の修正

• Fixed an issue where formatting wouldn't move UNION clause to a new line when it was used after INTO clause.
• Fixed an issue where the F12 shortcut was unavailable in Microsoft Visual Studio. The keyboard shortcut for "Script Object as ALTER" has been changed from F12 to Alt+Y for Visual Studio.

Released: Nov 20, 2023

10.14.2.4417 での更新項目

不具合の修正

• Fixed an issue where SQL Prompt crashed Microsoft SQL Server Management Studio (SSMS) 18.