SQL Prompt 10

SQL Prompt 10.1 release notes

SQL Prompt 10.1.7 - May 11th 2020

Fixes

  • Fixed an error with loading tab history options with different locales.

SQL Prompt 10.1.6 - May 11th 2020

Features

  • NOTE: The keyboard shortcut for "Show Open Tabs" has been changed from Ctrl+Q to Ctrl+Shift+X.

Fixes

  • SP-7985 : SQL Prompt no longer attempt to qualify objects when they are already qualified.
  • Fixed an error where running inline exec on certain procedures would change behaviour.
  • Fixed an error where SQL Prompt would fail to parse certain QUERY_STORE options.
  • Fixed an error where masked column definitions would sometimes fail to format.
  • Fixed an issue where the formatting error message was displayed incorrectly on invalid syntax around angle brackets.

SQL Prompt 10.1.5 - April 20th 2020

Fixes

  • SQL Prompt no longer uses a vulnerable version of SQLite.

SQL Prompt 10.1.4 - April 8th 2020

Features

  • SQL Prompt now supports SQL Server Management Studio v18.5.
  • You can now rename a closed tab in the Tab History window using the F2 keyboard shortcut.
  • The object definition window now remembers its size across SQL Server Management Studio sessions.
  • Added support for SQL Server 2019 syntax ACCELERATED_DATABASE_RECOVERY.

Fixes

  • SQL Prompt will no longer highlight the whole script after formatting.
  • Fixed an error when importing SQL Prompt options.
  • Fixed an issue that prevented renaming a closed tab in the Tab History window.
  • Fixed an issue with saving the column alias style option.

SQL Prompt 10.1.3 - March 30th 2020

Features

  • You can now autofix BP002 issues in your script.
  • You can now autofix BP012 issues in your script.
  • You can now autofix ST003 issues in your script.

Fixes

  • Fixed an issue where "Add/Remove Square Brackets" would fail on scripts containing STRING_SPLIT calls.
  • Fixed an issue where no suggestions were given following a THROW statement when using SQL Server 2019.


SQL Prompt 10.1.2 - March 19th 2020

Fixes

  • Fixed an issue where SQL Prompt was hanging on startup for some users.


SQL Prompt 10.1.1 - March 18th 2019

Fixes

  • Fixed an issue where scripts containing STRING_SPLIT calls inside OUTER APPLY statements would fail to format.
  • When triggering Format SQL, SQL Prompt no longer tries to run refactorings after one has failed.
  • Fixed an issue where PE010 issues would be reported for temporary tables.


SQL Prompt 10.1.0 - February 19th 2020

Features

  • Added the ability to autofix issues using the Alt + Enter keyboard shortcut.

Fixes

  • SP-7984 : SQL Prompt no longer reports code analysis issues when using built-in HierarchyID functions.
  • SP-7986 : SQL Prompt no longer adds square brackets around SET params in ADD TARGET statements.



Didn't find what you were looking for?