SQL Prompt 10.16 release notes
Published 04 December 2024
10.16.11.16409 - Released on 24 April 2025
Fixes
- Fixed formatting of OPENROWSET to make it consistent with other built in functions.
- Fixed an issue where SQL Prompt does not provide suggestions when IS DISTINCT FROM is used.
- Fixed an issue where "WAIT_AT_LOW_PRIORITY" is not a valid index option in 'CREATE INDEX'.
- Fixed an issue where TYPE was being formatted incorrectly.
- Fixed login issue in SSMS for Azure managed instance using Entra ID MFA.
10.16.10.16350 - Released on 21 April 2025
Fixes
- Fixed ST010 rule to avoid incorrect table alias suggestions within WAITFOR RECEIVE statements.
- Fixed SQL Prompt installation related issue for SSMS21.
- Fixed an issue where F12/Go to definition was not working on SSMS 21 (Preview 6).
10.16.9.16203 - Released on 01 April 2025
Fixes
Fixed an issue where SQL History failed to search starred, opened and closed queries.
- Fixed nested comments impacting parameter suggestions.
10.16.8.16147 - Released on 25 March 2025
Features
Added remove aggregate results functionality.
Fixes
- Fixed SQL Prompt not loading automatically on start of SSMS 21.
- Fixed error when offering parameter suggestions on Exec statement.
- Fixed formatting error when using AT TIMEZONE.
- Added missing suggestions for SERVERPROPERTY.
10.16.7.15960 - Released on 05 March 2025
Fixes
- Fixed issues in SQL History for SSMS 21 Preview
- Fixed formatting inconsistencies for SELECT with FOR XML
- Added fix for suggestions not loading for TRIM.
- Fix accuracy of average for grid aggregate results.
- Fixed suggestions for built in XML functions in cross apply
- Fixed SQL History search highlighting incorrect keyword.
10.16.6.15646 - Released on 17 February 2025
Features
Added support for SSMS 21 Preview. (Preview Feature) Refer Documentation.
10.16.5.15563 - Released on 07 February 2025
Fixes
- Fixed formatting of the SELECT statement nested within the CASE statements.
10.16.4.15307 - Released on 05 February 2025
Fixes
- Fixed issue where Formatting and Suggestions Stop Working with STRING_SPLIT() in Functions.
- Fixed issue where loading suggestions for Azure Synapse Serverless database was not working as expected.
10.16.3.14709 - Released on 16 January 2025
Features
- Added option to configure retention period and delete SQL history query versions based on set days.
Fixes
- Fixed a bug where SQL Prompt+ would show an error when logging in.
- Fix table option formatting for Azure dedicated pool.
- Fixed wrong formatting for CTE in TRY..CATCH block.
- Fixed wrong formatting for AS keyword in function.
10.16.2.14461 - Released on 02 January 2025
Fixes
- Fixed wrong auto completion issue for stored procedure parameter's default value.
10.16.1.14063 - Released on 18 December 2024
Features
- Added distinct count functionality in aggregate results.
Fixes
- Fixed an issue where SQL Prompt was displaying inaccurate SQL Warning.
10.16.0.13262 - Released on 04 December 2024
Fixes
- Fixed incorrect left alignment formatting issue for ALTER PROC.
- Fixed an issue impacting performance during parameter loading.
- Fixed an issue where spaces were removed after functions' close parenthesis in case statements.
- Fixed the lag in loading the SQL History window when opening it in SSMS.