SQL Prompt 10

Help for older versions available.

SQL Prompt 10.16 release notes

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.

Didn't find what you were looking for?