SQL Prompt Pro 新版本發表

Released: Oct 16, 2019

9.5.21 中的更新


  • Added a new ranked ordering option for suggestions.
  • Added suggestions support for ADD/DROP SENSITIVITY CLASSIFICATION syntax introduced in SQL Server 2019.
  • Added suggestions for COMPATIBILITY LEVEL values for all supported versions of SQL Server.


  • Fixed scenario that could lead to corruption of Prompt Options during export to a zip archive.
  • Fixed an issue which would sometimes cause formatting to fail when applied to a script containing a PIVOT clause within an UPDATE statement.
  • Fixed an...

Released: Oct 2, 2019

9.5.20 中的更新


  • Smart Rename and Split Table refactorings are now no longer supported for SQL Server 2000/2005.


  • SP-7804 : Fixed an issue with suggesting synonyms when schema/database filtering is enabled.
  • SP-7824 : Fixed an issue which would cause the Qualify Object Names refactoring to sometimes generate incorrect SQL when used on an UPDATE statement.
  • SP-7825 : Fixed keyboard shortcut _(Ctrl+Shift+E)_ for the [code analysis issue details pane](

Released: Sep 25, 2019

9.5.19 中的更新


  • Fixed an issue where square brackets were being incorrectly applied to IS_ROLEMEMBER during formatting.

Released: Sep 19, 2019

9.5.18 中的更新


  • Fixed an issue where column names would appear in reverse order when expanding wildcards.
  • SQL Prompt no longer reports PE017 warnings on built-in analytics functions.
  • Fixed an issue with incorrect handling of FROM built-in function.
  • Fixed rare crash that could occur when showing formatting issues during processing of invalid T-SQL code.
  • Fixed a bug that could lead to the wrong SQL Server version being loaded when connecting to Azure Managed Instances.

Released: Sep 6, 2019

9.5.16 中的更新


  • Fixed an issue with autocompleting when selecting DEFAULT from suggestions when specifying a filegroup.
  • Fixed issue with reconnecting tabs when reopening SSMS 18 multiple times.
  • Fixed issue where incorrect JOIN condition was suggested when using PIVOT tables.
  • Fixed an issue which caused a formatting error when attempting to format scripts containing column constraints with a FILLFACTOR index option.

Released: Aug 30, 2019

9.5.15 中的更新

Updates in 9.5.15

  • Fixed missing columns and parameters in suggestions when database filtering is enabled.
  • Changed some built-in snippets to not trigger code analysis warnings. This applies to new installs only.
  • Fixed an issue with execution warnings not being triggered for a selection under certain circumstances.
  • Fixed an issue where execution warnings would trigger for statements outside of the selected scope.
  • Fixed an issue with the ST008 autofix not working when EXEC statements were nested...

Released: Aug 22, 2019

9.5.14 中的更新


  • You can now automatically fix PE006 code analysis issues (table hint used) in your script.
  • You can now automatically fix SC006 code analysis issues in your script. This fix will change ALL line endings in your script to the expected CR/LF format.


  • SP-7650 : Fixed issue with reconnecting tabs that are connected using SQL Server authentication in SSMS 18.

Released: Aug 15, 2019

9.5.13 中的更新


  • The Check for Updates popup window now has a `Remind me next month` option.
  • You can now automatically fix ST008 code analysis issues in your script.
  • You can now automatically fix BP014 code analysis issues in your script.


  • SP-7717 : No longer updates indirectly referenced stored procedures when smart renaming a column.
  • SP-7725 : Fixed incorrect handling of STRING_SPLIT function.
  • SP-7728 : Dismissed notifications will now no longer re-appear when SSMS/VS is restarted.

Released: Jul 19, 2019

9.5.12 中的更新

Updates in 9.5.12

  • SP-7726 : Fixed an error when selecting "Select Top 1000 Rows" in the Object Explorer.

Released: Jul 18, 2019

9.5.11 中的更新

Updates in 9.5.11

  • Fixed an issue with incorrect handling of case sensitivity in Inline EXEC refactoring.
  • SP-7713 : SQL Prompt execution warnings no longer trim the beginning of object names in some scenarios.
  • SP-7715 : Fixed incorrect renaming of named parameters in Inline EXEC refactoring.
  • SP-7719 : Fixed an issue with code analysis rule BP014 and how it deals with persisted computed columns.
  • SP-7298 : Fixed an issue with built-in snippets triggering code analysis warnings.