SQL Prompt Pro のリリース
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.
Released: Jul 11, 2019
9.5.10 での更新項目
Updates in 9.5.10
- SP-7718 : Restores the results grid actions (Script as INSERT, Copy as IN clause and Open in Excel) that were accidentally removed by the previous update.
- SP-7720 : Fixed a crash on startup of SQL Prompt affecting some installations.
Released: Jul 10, 2019
9.5.9 での更新項目
Updates in 9.5.9
- In-product notifications that are dismissed will now not re-show until SQL Prompt is restarted.
