Released: May 14, 2019

v9.5.3 での更新項目

機能

• Now promotes recently used suggestions to the top of the suggestions box. This feature is enabled by default and persists only for the current session. It can be disabled on the Suggestions > Behavior page, under Show code suggestions.
• Added the ability to download the installer instead of running it when SQL Prompt informs that there is a new version available.

不具合の修正

• SP-7558 : Find Invalid Objects now reports triggers that are on non-existent tables.

Released: May 3, 2019

9.5.2 での更新項目

機能

• Added a `Show all issues` link to the autofix popup window.

不具合の修正

• Fixed an issue which was preventing SQL Prompt from launching when upgrading from a previous version.
• Fixed an issue which would sometimes cause unwanted newlines to be inserted into scripts generated from `Script Object as ALTER`.
• Fixed an issue which caused the `Smart Rename`, `Encapsulate Object as Stored Procedure` and `Split Table` features to not work for some users.

Released: Apr 25, 2019

9.5.0 での更新項目

機能

• Adds support for SQL Server Management Studio 18.
• Adds support for Visual Studio 2019.
• Now requires .Net Framework 4.7.2 or later.

不具合の修正

• SP-7522 : Fixed an issue of incorrect wildcard expansion from a nested SELECT containing CASE.
• SP-7545 : Fixed an issue where aliases were not being suggested within nested scopes.

Released: Apr 8, 2019

9.4.16 での更新項目

機能

• Optimized start-up time when a large number of tabs are being restored.

Released: Mar 28, 2019

9.4.15 での更新項目

機能

• You can now filter the suggestions that SQL Prompt shows by schemas, in addition to servers and databases.

不具合の修正

• Qualify Object Names no longer unqualifies parameters of rowset functions.
• EI028 no longer fires on IDENTITY columns.
• Format SQL no longer throws an error when trying to format TRIM statements that specify which characters to trim.

Released: Mar 20, 2019

9.4.14 での更新項目

機能

• Now supports the latest pre-release of SSMS 18.

Released: Mar 6, 2019

9.4.12 での更新項目

機能

• The Check for Updates popup now shows both the latest available version and your currently installed version.

不具合の修正

• Fixed a bug where attempting to insert semicolons on scripts containing ALTER EVENT SESSION START/STOP statements would sometimes result in incorrect semicolon placement.
• Fixed a bug where attempting to autofix some scripts would throw an error.
• Fixed a bug where InsertSemicolons refactoring would insert semicolons after GO command followed by a WITH clause.

Released: Feb 14, 2019

9.4.10 での更新項目

機能

• Based on customer feedback, the SQL Prompt experimental features are not going to be deprecated yet.
• The suggestions pop-up can be made transparent by holding down the Ctrl key, allowing you to see what is behind it.
• The keyboard shortcut to open code analysis issues has been changed to Ctrl+Shift+E.

不具合の修正

• BP014 no longer reports an issue with columns that don't declare NULL/NOT NULL if that column is a primary key.
• Qualify Object Names no longer tries to qualify column and index names when...

Released: Jan 9, 2019

9.4.7 での更新項目

機能

• Code analysis: You can now automatically fix code analysis issues directly from your editor window. Just click the yellow lightbulb and select the auto-fix option.
• The Code Analysis lightbulb is now much more responsive with its re-positioning when scrolling through your scripts.
• You can now bring up the List of Code Analysis Issues using the keyboard shortcut Ctrl+Shift+Y.

不具合の修正

• SP-6956 : Fixed typo in built-in method (CONCAT_WS instead of CONCAT_WD) when running PE017.
• SP-7127 : BP...

Released: Dec 13, 2018

9.4.6 での更新項目

機能

• You can automatically fix BP022 issues in your script (it replaces the usage of the MONEY or SMALLMONEY datatype with the Decimal(19, 4) datatype).
• "Check for Updates" renders as a popup in the bottom right rather than as a big modal.
  • User can dismiss the popup, setting it to remind them tomorrow, in a week or skip the version entirely.

不具合の修正

• SP-6956 : PE017 correctly considers the following functions as built-in system ones:
  • CONCAT
  • CONCAT_WD
  • FORMAT
  • TRANSLATE
  • TRIM
  • DATEFROMPARTS
• SP-...