Released: Oct 28, 2019

Actualizaciones en 9.5.23

Correcciones

• Fixed an issue which would sometimes cause the Tab History/Code Analysis UI to fail to load.

Released: Oct 24, 2019

Actualizaciones en 9.5.22

Características

• Enhanced Tab History *
  • You can now star the tabs you use most often, so they're easier to find and restore when you need them.
  • Tabs are now shown in time buckets, making them easier to search through.
• Added support for the APPROX_COUNT_DISTINCT aggregate function, introduced in SQL Server 2019.
• Added support for the index options RESUMABLE and MAX_DURATION in CREATE INDEX statements, introduced in SQL Server 2019.

* SQL Prompt keeps a history of query tabs you open in Management...

Released: Oct 16, 2019

Actualizaciones en 9.5.21

Características

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

Correcciones

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

Released: Oct 2, 2019

Actualizaciones en 9.5.20

Características

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

Correcciones

• 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

Actualizaciones en 9.5.19

Correcciones

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

Released: Sep 19, 2019

Actualizaciones en 9.5.18

Correcciones

• 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

Actualizaciones en 9.5.16

Correcciones

• 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 22, 2019

Actualizaciones en 9.5.14

Características

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

Correcciones

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

Released: Aug 15, 2019

Actualizaciones en 9.5.13

Características

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

Correcciones

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