Features

• SQL Prompt Pro - Added the ability to duplicate a tab in Microsoft SQL Server Management Studio (SSMS).

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.

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.

Fixes

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

Fixes

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

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.

Features

• SQL Prompt Pro - 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.

Features

• SQL Prompt Pro - Added support for GREATEST AND LEAST for Microsoft Azure SQL Databases and Managed Instances.
• SQL Prompt Pro - Added support for CURRENT_TIMEZONE and CURRENT_TIMEZONE_ID in Azure SQL Managed Instances.

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 auto-completion.

Features

• SQL Prompt Pro - 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 auto-completion.

Fixes

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

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.

Features

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

Fixes

• Fixed an issue where canceling 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.

Features

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

Features

• Performance Improvements.

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.

Fixes

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

Features

• SQL Prompt Pro - Added support for ALL and DISTINCT arguments when using some SQL aggregate functions.
• SQL Prompt Pro - Added support for graph search patterns when using merge statements.
• SQL Prompt Pro - Added support for underscores within identifiers prefixed with $.
• SQL Prompt Pro - Added support for storing snippets in subfolders inside the configured snippets directory.

Fixes

• 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.

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.

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.

Features

• SQL Prompt Pro - 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.