SQL Prompt Pro のリリース
Released: Jan 24, 2024
10.14.6.5992 での更新項目
機能
- Added intellisense support to EXTENDED EVENTS syntax.
不具合の修正
- 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.
Released: Jan 4, 2024
10.14.5.5385 での更新項目
機能
- Added the option to disable formatting for groups of single-line comments.
不具合の修正
- 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.
Released: Dec 7, 2023
10.14.4.4865 での更新項目
不具合の修正
- 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
10.14.3.4664 での更新項目
不具合の修正
- 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
10.14.2.4417 での更新項目
不具合の修正
- Fixed an issue where SQL Prompt crashed Microsoft SQL Server Management Studio (SSMS) 18.
Released: Nov 15, 2023
10.14.1.4347 での更新項目
不具合の修正
- Fixed an issue where formatting scripts with a CASE clause would occasionally cause an error.
Released: Nov 7, 2023
10.14.0.4064 での更新項目
機能
- Added Prompt+ AI as a preview feature.
不具合の修正
- 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
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
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
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...
