10.14.23.11448 - Released on 03 October 2024

Fixes

• Fixed an issue where SQL Prompt+ would fail to log in.

10.14.22.11347 - Released on 18 September 2024

Features

• Added option for "Open in Excel" where numeric values longer than 15 digits will be saved as text to prevent Excel rounding.
• Default values of Stored Procedure Parameters are now being displayed in suggestions.

Fixes

• Fixed renaming aliases whose name is the same as the object name.
• Fixed an issue where SQL Prompt wouldn't highlight all matched objects in some queries.
• Fixed DELETE statement formatting with TOP() filter.

• Fixed an issue where formatting a CTE places the definition on the same line as the RETURN statement.

• Fixed an issue where the SQL History search did not highlight all instances of the searched phrase.
• Fixed an issue where formatting multiline comments would fail in specific scenarios.
• Fixed UPDATE() tooltip redirecting to incorrect documentation page.
• Fixed an issue with the formatting of the selected area.
• Fixed an issue where SQL Prompt wouldn't show procedure synonym alter script after pressing F12 key.
• Fixed an issue with the loading window disappearing in SSMS.

10.14.21.9884 - Released on 14th June 2024

Features

• Added support for Synapse Serverless SQL Pools.

Fixes

• Fixed Prompt+ in SSMS 18.
• Fixed few issues which caused data types to be missing/invalid for aliased columns.
• Fixed Apply Column Alias Style with WINDOW OVER clause.
• Fixed invalid data type of aliased columns when using arithmetic operators.

10.14.20.9646 - Released on 05 June 2024

Features

• Performance improvements for SQL Prompt+.

Fixes

• Fixed some errors in SQL Prompt+.

10.14.19.9311 - Released on 23 May 2024

Fixes

• Fixed an issue where Unformat refactoring would leave unnecessary space.
• Fixed an issue where the SUSER_NAME() tooltip would show an incorrect return type.
• Fixed detecting data type for columns created using OVER clause nested in CASE.
• Fixed an issue where adding alias to the column with OVER clause could fail with error.

10.14.18.8999 - Released on 09 May 2024

Features

• Allow the "Enable Code Analysis" option to be set separately for SSMS and Visual Studio.

Fixes

• Fixed an issue where Prompt+ AI could lose focus.
• Fixed an issue where SQL Prompt was failing to format query with ALTER DATABASE MODIFY statement.
• Fixed an issue with the product installer resetting language settings in VS 2022.
• Fixed an issue with multiline comment formatting consistency when the "Tabs where possible" tab behavior option is enabled.

10.14.17.8739 - Released on 01 May 2024

Features

• Performance improvements for SQL Prompt+.

10.14.16.8679 - Released on 30 April 2024

Features

• Added multiline comment formatting option for recognizing common comment patterns.

Fixes

• Fixed an issue with multiline comments not respecting "tab behavior".

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.