SQL Prompt Pro Releases
Released: Apr 19, 2024
Updates in 10.14.15.8425
Fixes
- Fixed an issue where Prompt+ AI Assistant could cause SSMS to crash.
Released: Apr 15, 2024
Updates in 10.14.14.8187
Fixes
- Fixed an issue where Prompt+ AI Assistant would cause a crash in SSMS 19.
Released: Apr 11, 2024
Updates in 10.14.13.8134
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.
Released: Apr 2, 2024
Updates in 10.14.12.7945
Fixes
- Fixed an issue with SSMS 20 prompting TextMgrP.dll error upon launch.
Released: Mar 28, 2024
Updates in 10.14.11.7894
Features
- Added support for Microsoft SQL Server Management Studio (SSMS) 20.
Released: Mar 14, 2024
Updates in 10.14.10.7538
Fixes
- Fixed exporting results to Microsoft Excel format.
- Fixed "Could not load file or assembly System.Memory" exception, occurring when using SqlPrompt.Format.CommandLine.exe from FormatCommandLine.zip.
Released: Feb 29, 2024
Updates in 10.14.9.7331
Features
- Add refactoring for converting sp_executesql expressions 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 built-in function after cross applying a 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.
Released: Feb 8, 2024
Updates in 10.14.8.6563
Features
- Added suggestions in LAG, LEAD and formatting in LAG, LEAD, FIRST/LAST_VALUE for RESPECT/IGNORE NULLS.
Released: Jan 31, 2024
Updates in 10.14.7.6275
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.
Released: Jan 24, 2024
Updates in 10.14.6.5992
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.