Lancements de SQL Prompt Pro

Released: Feb 19, 2020

Mises à jour de 10.1.x

10.1.3

Updated Mar 30, 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.

10.1.2

Updated Mar 19, 2020

Fixes

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

Released: Nov 6, 2019

Mises à jour de 10.0.x

10.0.11

Updated Feb 5, 2020

Features

  • Added suggestions support for new permission types in SQL Server 2019.

Fixes

  • Fixed an issue with columns sometimes not being qualified when qualifying object names.
  • Fixed an issue with some functionality not appearing for servers connected using Windows authentication.

10.0.10

Updated Jan 29, 2020

Fixes

  • Fixed an issue that caused SSMS to crash when connecting to an Azure server using Multi-Factor Authentication.

10.0.9

Updated Jan 28, 2020

Features

  • Added...

Released: Oct 28, 2019

Mises à jour de 9.5.23

Correctifs

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

Released: Oct 24, 2019

Mises à jour de 9.5.22

Fonctionnalités

  • 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

Mises à jour de 9.5.21

Fonctionnalités

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

Correctifs

  • 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

Mises à jour de 9.5.20

Fonctionnalités

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

Correctifs

  • 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

Mises à jour de 9.5.19

Correctifs

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

Released: Sep 19, 2019

Mises à jour de 9.5.18

Correctifs

  • 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

Mises à jour de 9.5.16

Correctifs

  • 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

Mises à jour de 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...