10.13.16.3650 - Released on 26 October 2023

Fixes

• Fixed an issue where tabs would not restore when connection was of Active Directory Password type.
• Fixed connecting to Azure via Azure Active Directory Password in SSMS 18.
• Fixed an issue where comments would not align correctly.
• Fixed an issue where column data type was missing in temp table created from SELECT with CASE.

10.13.15.3135 - Released on 03 October 2023

Features

• Added support to ISJSON optional parameter, added JSON_PATH_EXISTS support to Azure.

Fixes

• Fixed Linked Server suggestions not working with OLE DB Driver.

10.13.14.2694 - Released on 13 September 2023

Fixes

• Fixed style override when saving SQL Prompt settings.
• Fixed an issue with SQL History ignoring numbers in search.
• Fixed an issue where single line comments were not properly formatted.
• Fixed registry key "StoreSettingsUnderRoaming" not impacting all the required files.
• Fixed an issue where restoring settings didn't reset the formatting style to default.

10.13.13.2147 - Released on 22 August 2023

Features

• Added a feature for saving SQL History advanced search settings.

• Added support for multiple syntaxes on Azure SQL database.

Fixes

• Fixed an issue with connecting via Azure Active Directory with MFA for SSMS19.1.
• Fixed AT TIME ZONE expressions recognition.
• Fixed formatting issue for TRIM in SQL Server 2022.
• Fixed "Could not load file or assembly System.Threading.Tasks.Extensions" error occuring when using Azure Active Directory authentication methods.

• Fixed an issue with columns not having data type when created by CAST function.

10.13.12.1701 - Released on 19 July 2023

Features

• Added advanced search tooltip for finding exact matches in SQL History by using double quotes (e.g., "create view").

Fixes

• Fixed an issue where an unwanted space/tab was being added into the multi-part identifier in the WHERE clause.
• Fixed an issue where OPENXML statement wasn't recognized in Azure SQL Database.
• Fixed an issue that prevented exact match searches in SQL History.

• Fixed an issue that prevented Smart Rename to rename column with same name but different case on case sensitive database.

10.13.11.1536 - Released on 28 June 2023

Features

• Provided better feedback when the options fail to save.
• Added support for the SqlServer2022 functions: GENERATE_SERIES, JSON_PATH_EXISTS, JSON_OBJECT, JSON_ARRAY, GREATEST.
• Adjusted FindInvalidObjects comboboxes dropdown width.

• Added a feature for closing query in SQL History advanced search.

Fixes

• Fixed an issue where OdbcPrec and OdbcScale functions weren't recognized in SQL Server 2022.
• Fixed an issue with database related suggestions not appearing in Visual studio.

• Fixed an issue where incorrect column suggestions were provided when creating a foreign key using ALTER TABLE with REFERENCES.

10.13.10.1356 - Released on 14 June 2023

Features

• Added support for RESPECT NULLS and IGNORE NULLS syntax.
• Added support for SQL Server 2022 DATETRUNC function.
• Added support for SqlServer2022 LEAST, STRING_SPLIT, LEFT_SHIFT and RIGHT_SHIFT syntax.
• Added a feature for setting parentheses spacing only after parentheses in function calls.

• Changed Excel export result of datetime where time of day matches 0.

Fixes

• Fixed an issue with formatting query with a WINDOW function.
• Fixed an issue with parser not recognizing Odbc builtin functions.
• Fixed an issue where columns from outer SELECT would not show up in inner SELECT when using CROSS APPLY.
• Fixed an issue with List of Code Analysis window not rendering its content while Optimize rendering for screens with different pixel densities is enabled in VS2019-2022.

• Fixed an issue where script preview used the wrong tab size, and disabled the tab size setting when indentation style is set to tabs.

10.13.9.869 - Released on 24 May 2023

Features

• Added support for SqlServer2022 DATE_BUCKET syntax.
• Added support for SqlServer2016-SqlServer2022 CET(Create External Table) statement syntax.

• Added support for SqlServer2022 CETAS(Create External Table As Select) statement syntax.

Fixes

• Fixed an issue where SQL History sometimes put queries to wrong date category.

• Fixed an issue where changing SELECT INTO with columns to CREATE TABLE could result in wrong column order.

10.13.8.680 - Released on 11 May 2023

Fixes

• Fixed an issue with Tab coloring in SSMS19
• Fixed an issue with empty whitespaces being part of prompt suggestions.
• Fixed an issue with Tabs not reconnecting on SSMS 19.
• Fixed an issue with temporary table definition preview when hovering over table name.
• Fixed an issue with SSMS 19.02 prompting TextMgrP.dll error upon launch.
• Fixed issue where SqlPrompt.Format.CommandLine.exe would crash while closing SQL Compare.

10.13.7.360 - Released on 28 March 2023

Features

• Added sort options inside SQL History advanced search.

Fixes

• Fixed an issue with exporting EXCEL document which caused it to crash for some system cultures.
• Fixed an issue where uppercase was applied to columns from OPENJSON when formatting SQL query.
• Fixed an issue where Qualify Object Name feature replaced wrong parts of the script.
• Fixed an issue where snippet was duplicated instead of modified and color options didn't work.
• Fixed an issue with BEGIN and END wrapping casted on ALTER PROCEDURE.

10.13.6.254 - Released on 14 March 2023

Fixes

• Fixed an issue where windowing functions were suggested in GROUP BY clause while they shouldn't.
• Fixed an issue where auto complete feature didn't include full text index for views.
• Fixed an issue with closing query inside SQL History.

10.13.5.16 - Released on 21 February 2023

Fixes

• INLINE option is now suggested inside function's WITH clause.
• Fixed saving settings in SQL Prompt options for Visual Studio.
• Fixed an issue with starting the application when the strong name check option is active.
• Removed incorrect message about SQL Server 2000 support when trying to use a linked server.
• Fixed an issue where suggestions were not available if column name was used in CROSS APPLY VALUES statement.
• Fixed an issue where attempting to format query containing CROSS APPLY VALUES statement would throw an error.
• Fixed an issue with EXEC WITH RESULT SETS formatting.
• Fixed Split Table and Smart Rename for SSMS 19.
• Fixed an issue where adding columns to INSERT statement wouldn't work with temporary tables and could pick wrong table.
• The Smart Rename option will no longer appear for default constraints.

10.13.4.32349 - Released on 19 January 2023

Features

• SQL History: Improved how search results are highlighted in the preview window.

Fixes

• Fixed a formatting issue where CAST function wasn't formatted like other functions.
• Fixed an issue where the installer could fail to detect SSMS 19 Preview 4 being installed.
• Fixed an issue where a query that is part of a solution cannot be re-opened.
• Fixed an issue where Export To Excel could fail when exporting a large number of rows.

• Fixed an issue where opening SQL History from the command palette sometimes resulted in an empty window.

10.13.3.32087 - Released on 04 January 2023

Features

• Added support for SSMS 19 Preview 4. Please note this and later releases will not work with older previews of SSMS 19.
• SQL History: Improved searching.
• SQL History: Added the ability to see open/closed queries.

10.13.2.31952 - Released on 14 December 2022

Fixes

• Fixed an upgrade issue for users previously running a version of SQL Prompt older than v9.5.22.

10.13.1.31417 - Released on 18 November 2022

Features

• SQL History: Added the ability to see only starred queries.
• SQL History: Added the ability to open queries/histories by double-clicking on them.

10.13.0.31319 - Released on 10 November 2022

Features

• SQL History: Keep a copy of all queries that you write and execute, along with a history of each, enabling you to return to what you were previously working on.

Fixes

• Fixed a crash that could occur relating to Redgate Platform access tokens.