SQL Prompt 10

SQL Prompt 10.11 release notes

10.11.12.27800 - Released on 16 May 2022

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.

10.11.11.27632 - Released on 28 April 2022

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.


10.11.10.27545 - Released on 20 April 2022

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.


10.11.9.27382 - Released on 30 March 2022

Uninstall SQL Prompt v10.11.8 before installing this version

If you have installed SQL Prompt v10.11.8, please uninstall that version before installing SQL Prompt v10.11.9.

Fixes

  • Fixed a crash introduced in v10.11.8.


10.11.8.27379 - Released on 30 March 2022

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


10.11.7.27287 - Released on 23 March 2022

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


10.11.6.27098 - Released on 09 March 2022

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


10.11.5.26913 - Released on 25 February 2022

Features

  • Added a command to the command palette to check whether the current connection's password has appeared in a data breach (using Have I Been Pwned?).

Fixes

  • Improved the performance of the command palette when containing a large number of items.
  • 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.


10.11.4.26759 - Released on 17th February 2022

Fixes

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


10.11.3.26715 - Released on 16th February 2022

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.


10.11.2.26629 - Released on 9th February 2022

Features

  • Added the ability to change SQL Prompt's options from the command palette.
  • Added the configured keyboard shortcuts for commands in the command palette.


Fixes

  • Fixed locating some object types (users, database roles) in Object Explorer from the command palette.
  • Added help context to the command palette for default constraints, check constraints, unique constraints, and primary keys.
  • 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 Autofix PE003 (Creation of table by SELECT INTO statement) may not work when objects were qualified.
  • Fixed an issue where Autofix BP004 (INSERT without column list) could show an error when using temporary tables.


10.11.0.26431 - Released on 1st February 2022

Features


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.




Didn't find what you were looking for?