SQL Prompt Pro Releases

Released: Dec 7, 2023

Updates in 10.14.4.4865

Fehlerkorrekturen

  • 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

Updates in 10.14.3.4664

Fehlerkorrekturen

  • 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

Updates in 10.14.2.4417

Fehlerkorrekturen

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

Released: Nov 15, 2023

Updates in 10.14.1.4347

Fehlerkorrekturen

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

Released: Nov 7, 2023

Updates in 10.14.0.4064

Funktionen

  • Added Prompt+ AI as a preview feature.

Fehlerkorrekturen

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

Released: Nov 10, 2022

Updates in 10.13.x

v10.13.16.3650

Updated Oct 26, 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.

v10.13.15.3135

Updated Oct 3, 2023

Features

  • Added support to ISJSON optional parameter.
  • Added JSON_PATH_EXISTS support to Microsoft...

Released: May 26, 2022

Updates in 10.12.x

v10.12.6.30951

Updated Oct 20, 2022

Fixes

  • Fixed Azure MFA connections for SSMS 19 Preview 3.
  • Fixed an issue with renaming tabs in Tab History.
  • Altered Export to Excel to treat numeric values as numbers in Excel.

v10.12.5.30313

Updated Sep 28, 2022

Fixes

  • Fixed an issue where the SQL Prompt View in the SQL Compare diff window was not working.
  • Fixed an issue where Export to Excel was always using a dot as the decimal separator instead of the using the one set by the current locale.

Released: Feb 1, 2022

Updates in 10.11.x

v10.11.12.27800

Updated May 16, 2022

Fixes

  • Fixed an issue when applying autofixes in bulk.
  • Fixed an issue where try_convert formatting could cause an error.
  • Fixed an issue where Qualify Object Names would incorrectly qualify with synonyms from other schemas.
  • Fixed an issue when auto completing INSERT INTO statements for tables in a different database to the current connection.

v10.11.11.27632

Updated Apr 28, 2022

Fixes

  • Fixed an issue where the command palette wouldn't open in Visual Studio...

Released: Nov 30, 2021

Updates in 10.10.x

v10.10.4.26165

Updated Jan 18, 2022

Features

  • Improved detection when Replace Select Into With Create Table autofix is available.
  • Added the ability to open SQL Dependency Tracker from the object definition window when viewing an object's dependencies. (SQL Toolbelt Essentials subscription license required).
  • Added suggestions for existing resource pools for ALTER and DROP statements.

Fixes

  • Fixed an error with the autofix for Add Columns To Insert Statement where it would fail for certain syntax...

Released: Nov 9, 2021

Updates in 10.9.x

v10.9.3.25270

Updated Nov 24, 2021

Features

  • Added "no-layout" option to command line formatter.
  • Improved suggestions for CREATE TABLE.

Fixes

  • Fixed an issue where 'Restore defaults' in the options menu could require multiple attempts to restore default settings.
  • Resolved issue with the Bulk Formatter.
  • Fixed an issue where SQL Prompt in Visual Studio 2022 may crash when importing and exporting settings.
  • Fixed an issue where Smart Rename would crash when using the latest frequent release of SQL...