10.14.15.8425 - Released on 19 April 2024

Fixes

• Fixed an issue where Prompt+ AI Assistant could cause SSMS to crash.

10.14.14.8187 - Released on 15 April 2024

Fixes

• Fixed an issue where Prompt+ AI Assistant would cause a crash in SSMS 19

10.14.13.8134 - Released on 11 April 2024

Features

• Added syntax for TRIM with LEADING, TRAILING, or BOTH options to Azure SQL Databases.

Fixes

• Fixed an issue where some parameters for DBCC CLONEDATABASE were missing in suggestions.
• Fixed an issue where some properties for DATABASEPROPERTYEX were missing in suggestions.

10.14.12.7945 - Released on 02 April 2024

Fixes

• Fixed an issue with SSMS 20 prompting TextMgrP.dll error upon launch.

10.14.11.7894 - Released on 28 March 2024

Features

• Added support for SQL Server Management Studio 20.

10.14.10.7538 - Released on 14 March 2024

Fixes

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

10.14.9.7331 - Released on 29 February 2024

Features

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

• Added formatting for WINDOW clause. 

Fixes

• Fixed an issue where casing wouldn't be applied to a builtinfunction after cross apply 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.

10.14.8.6563 - Released on 08 February 2024

Features

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

10.14.7.6275 - Released on 31 January 2024

Fixes

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

10.14.6.5992 - Released on 24 January 2024

Features

• Added intellisense support to EXTENDED EVENTS syntax.

Fixes

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

10.14.5.5385 - Released on 04 January 2024

Features

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

Fixes

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

10.14.4.4865 - Released on 07 December 2023

Fixes

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

10.14.3.4664 - Released on 29 November 2023

Fixes

• 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 Visual Studio. The keyboard shortcut for "Script Object as ALTER" has been changed from F12 to Alt+Y for Visual Studio.

10.14.2.4417 - Released on 20 November 2023

Fixes

• Fixed an issue where SQL Prompt crashes SSMS18.

10.14.1.4347 - Released on 15 November 2023

Fixes

• Fixed an issue where formatting script with CASE clause would occasionally cause an error.

10.14.0.4064 - Released on 07 November 2023

Features

• Added Prompt+ AI (preview feature). For more details see here. Before you use this feature you will be required to accept a separate EULA.

Fixes

• Fixed an issue where formatting query with URL keyword would cause parsing errors.
• Fixed an issue where UNION clause dealigned INTO item during formatting with Align Items Across clauses turned on.

• Fixed an issue where alias functionality was not working for objects with schema names.