Fixes

• Fixed an issue when applying autofixes in bulk.
• Fixed an issue where try_convert formatting could cause an error.
• Fixed an issue where Qualify Object Names would incorrectly qualify with synonyms from other schemas.
• Fixed an issue when auto completing INSERT INTO statements for tables in a different database to the current connection.

Fixes

• Fixed an issue where the command palette wouldn't open in Visual Studio 2019/2022.
• Fixed an issue where nullif and try_convert did not respect function parenthesis settings when formatted.

Features

• Improved suggestions for CREATE USER.

Fixes

• Fixed an issue where a semicolon was being incorrectly added when formatting a CREATE USER...FROM EXTERNAL PROVIDER statement.
• Fixed an issue where constraints were incorrectly being qualified when running the Qualify Object Names action.

Fixes

• Fixed a crash introduced in v10.11.8.
  • Note: If you have installed SQL Prompt v10.11.8, please uninstall that version before installing SQL Prompt v10.11.9.

Fixes

• Fixed an issue where autofixes could fail when applied in bulk from the code analysis light bulb.
• Fixed an issue where a crash could sometimes occur when upgrading formatting styles on startup.
• Fixed a crash in early versions of SSMS 2016 when restoring tabs using tab history.
• Fixed an issue where some commands were not showing in Visual Studio (Copy as IN Clause, Find Invalid Objects, Open in Excel, Script Results as INSERT, Split Table).

Fixes

• Fixed an issue where the command palette sometimes fails to load the database objects.
• Fixed an issue where some commands were not showing in Visual Studio (Copy as IN Clause, Find Invalid Objects, Open in Excel, Script Results as INSERT, Split Table).

Fixes

• Fixed an issue where certain features were not available in Visual Studio (including Script As Alter).
• Fixed a crash when opening results in Excel when the results contain a NULL datetime value.
• Fixed a crash when Script As Alter encounters an error.
• Fixed an issue where the Add Square Brackets refactoring would fail when column names started with $.

Features

• Added a command to the command palette to check whether the current connection's password has appeared in a data breach.
• Improved the performance of the command palette when it contains a large number of items.

Fixes

• Fixed an issue where additional invalid columns would be suggested when using graph statements.
• Fixed an issue where physical names would be used for computed graph columns, instead of the logical name.
• Fixed an issue where table names would be incorrectly qualified in graph match clauses.

Fixes

• Fixed an issue where errors may be shown when a script has certain code analysis issues.

Fixes

• Fixed a crash when running some commands from the command palette.
• Fixed an issue where NULL values weren't being treated as blank cells when opening query results in Excel.
• Fixed an issue where Autofix ST008 (Use named parameters when calling procedure) would be shown for System Extended Stored Procedures (not supported).
• Fixed an issue where SQL Server 2000 warning messages could be shown when qualifying servers.

Features

• Added the ability to change SQL Prompt's options from the command palette.
• Added configured keyboard shortcuts for commands in the command palette.
• Added help context to the command palette for default constraints, check constraints, unique constraints, and primary keys.

Fixes

• Fixed locating some object types (users, database roles) in Object Explorer from the command palette.
• Prevented database users, database roles, and server roles from being shown twice in the command palette.
• Fixed suggestions for SET STATISTICS when setting multiple options.
• Fixed an issue where Open In Excel would only export the first results set.
• Fixed an issue where Creation of table by SELECT INTO statement may not work when objects were qualified.
• Fixed an issue where INSERT without column list could show an error when using temporary tables.

Features

• Added command palette (press Alt+S to open), which provides a fast way to navigate SQL Prompt and SSMS functionality via a single keyboard shortcut.

Fixes

• Fixed an issue where refreshing suggestions would not refresh other databases referenced in a query.
• Fixed an issue where the Formatting Styles dialog would open with parts off-screen, resulting in certain buttons not being visible.
• Fixed an issue where the Script as Insert and Copy as In options from the results grid would not copy DATE types correctly.