10.6.19.22009 - Released on 20th July 2021

Features

• Added the ability to duplicate a tab in SSMS.

10.6.18.21710 - Released on 7th July 2021

Features

• Changed the way objects are qualified such that the default schema is chosen where multiple schemas match.

Fixes

• Fixed the crash when using summarize scripts where the script is invalid.

10.6.17.21532 - Released on 30th June 2021

Fixes

• Fixed an issue where connections to multiple contained Azure SQL databases may prevent suggestions appearing.

• Fixed an issue where sys objects may not be suggested when connecting to Azure databases without access to the master database.

• Fixed a crash when opening suggestions containing the German eszett (ß) character.

10.6.16.21150 - Released on 17th June 2021

Fixes

• Fixed a crash when autocompleting reserved words and table variables.

10.6.15.21056 - Released on 15th June 2021

Fixes

• Fixed an issue where the Quick Actions menu items did not perform the selected action.

10.6.14.20978 - Released on 11th June 2021

Fixes

• Fixed an issue where an exception would be shown after multiple failed refactorings.
• Fixed an issue where SQL Prompt would crash when opening the context menu of an editor window tab.

10.6.13.20795 - Released on 7th June 2021

Features

• Changed the Summarize Script dialog to allow interaction with the SSMS window when open.

Fixes

• Fixed a crash on startup in Visual Studio 2015 and 2017.

10.6.12.20269 - Released on 18th May 2021

Features

• Added support for GREATEST AND LEAST for Azure SQL Database and Managed Instance.
• Added support for CURRENT_TIMEZONE and CURRENT_TIMEZONE_ID in Azure SQL Managed Instance.

Fixes

• Fixed an issue where SQL Prompt may crash when using views on linked servers.
• Fixed an issue where columns with a numeric datatype in temporary tables would always have NULL as the placeholder value when using the INSERT INTO autocompletion.

10.6.11.19980 - Released on 11th May 2021

Features

• Improved the performance of tab reconnection.

Fixes

• Fixed an issue where function names had square brackets added to them when formatting.
• Fixed an issue where columns with a numeric datatype would always have NULL as the placeholder value when using the INSERT INTO autocompletion.

10.6.10.19533 - Released on 27th April 2021

Fixes

• Fixed an issue where opening results in Excel would sometimes result in an error when NULL values are present in the results.

10.6.9.19437 - Released on 26th April 2021

Fixes

• Fixed an issue where opening results in Excel would sometimes result in an error.
• Fixed an issue where SQL Prompt would sometimes look in the SQL Prompt 9 directory for snippets.

10.6.8.19311 - Released on 21st April 2021

Features

• Added support for DROP IF EXISTS for Azure SQL Server.
• You can now auto-fix BP004 issues in your script.
• You can now auto-fix BP008 issues in your script.
• You can now auto-fix BP009 issues in your script.
• You can now auto-fix BP010 issues in your script.
• You can now auto-fix BP023 issues in your script.
• You can now auto-fix DEP021 issues in your script.
• You can now auto-fix EI003 issues in your script.
• You can now auto-fix MI003 issues in your script.
• You can now auto-fix PE001 issues in your script.
• You can now auto-fix PE002 issues in your script.
• You can now auto-fix PE003 issues in your script.
• You can now auto-fix PE023 issues in your script.
• You can now auto-fix ST002 issues in your script.
• You can now auto-fix ST010 issues in your script.

Fixes

• Fixed an issue where cancelling a format could break subsequent formatting operations.
• Fixed an issue where formatting operations could take significant time to cancel.
• Fixed an issue with not recognizing template parameters with spaces in their names.
• Fixed an issue where opening results in Excel would sometimes result in an error.
• Fixed an issue where default snippets would not be added when selecting the add default snippets option.

10.6.7.19129 - Released on 13th April 2021

Fixes

• Fixed an issue where snippet shortcuts may become case sensitive.

10.6.6.18829 - Released on 29th March 2021

Features

• Performance Improvements.

10.6.5.18584 - Released on 12th March 2021

Fixes

• Fixed an issue where the insert semicolons refactoring could fail when applied on a selection within a BEGIN END block.
• Fixed an issue where snippets starting with certain characters did not load.
• Fixed an issue where master database connection error may show incorrectly when connecting to Azure servers.
• Fixed an issue where previous versions of visual studio without SSDT would block the installer.

10.6.4.18350 - Released on 3rd March 2021

Fixes

• Fixed an issue where choosing a suggestion in a query window causes unnecessary disk activity.

10.6.3.18228 - Released on 23rd February 2021

Features

• Added support for ALL and DISTINCT arguments when using some SQL aggregate functions.
• Added support for graph search patterns when using merge statements.
• Added support for underscores within identifiers prefixed with $.

Fixes

• Added support for storing snippets in subfolders inside the configured snippets directory.
• Fixed an issue where the SQL Server Data Tools (SSDT) is required error would be shown inconsistently when installing SQL Prompt.
• Fixed an issue when upgrading snippets when a snippet's shortcut matches a Windows reserved file name.

10.6.2.18034 - Released on 15th February 2021

Fixes

• Fixed an issue where SQL Prompt would disable the built in SSMS auto list members feature when the product was unlicensed.
• Prevented tab history options being displayed in Visual Studio as tab history is not supported in that IDE.
• Fixed an issue where opening results in Excel would sometimes result in an error.
• Disabled code analysis rule ST011 (Consider using table variable instead of temporary table) as it is no longer recommended advice.

10.6.1.17779 - Released on 4th February 2021

Fixes

• Fixed an issue where editing a snippet can sometimes cause an error on startup of SQL Prompt.
• Fixed an issue where changes made to the currently active formatting style are not used until SSMS is restarted.
• Fixed a performance issue introduced in SQL Prompt 10.6.

10.6.0.17688 - Released on 1st February 2021

Features

• Snippets are now stored in a new format.

Fixes

• Fixed an issue which could cause formatting to fail when multiple query hints are used in the same query.