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