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

Released: Oct 17, 2018

9.4 での更新項目

機能

• You can now automatically fix ST006 code analysis issues in your script:
  • Issues that are fixable are represented by an orange lightbulb icon in the sidebar, rather than the traditional blue one.
  • Clicking on the lightbulb will show the issue details pane, which when applicable, will contain a button labeled "Apply Fix".
  • Clicking this button will automatically fix the relevant issue in the script.
• Added auto completion for the following query hints:
  • KEEP UNION
  • MAX_GRANT_PERCENT
  • MIN_GRANT...

Released: Sep 26, 2018

9.3 での更新項目

機能

• You can now refactor INSERT statements into UPDATE statements, making it easier to update the data in your tables.
  • This can be triggered by either right clicking in the script window and selecting the command, or by using the keyboard shortcut Ctrl+B, Ctrl+P.
  • The refactoring automatically adds a default WHERE clause, which you can customize to suit your needs.
• You can now go directly to the Product Learning section of the Redgate Hub from within SQL Prompt.
  • Click SQL Prompt > Help &gt...

Released: Jun 27, 2018

9.2 での更新項目

機能

• In addition to "as you type" code analysis, you can now also display a dockable list of all the issues in your currently selected script window.
  This is accessible via the Prompt menu: 'Show List of Code Analysis Issues'.
• Improved performance of background code analysis.

不具合の修正

• Collapsed alignment layout options could cause formatting to fail when dealing with optional parentheses.

Released: Feb 21, 2018

9.1 での更新項目

機能

• Code analysis settings can now be saved to individual files (.casettings) and shared amongst your team.

不具合の修正

• Fixed - Missing space before NOT after IF RIGHT(...).
• Fixed - Cannot insert semicolons for DBCC statements.
• Fixed- Exception when closing editor window after using snippets.
• Fixed - STRING_AGG intellisense.

Released: Jan 31, 2018

9.0.8 での更新項目

機能

• Code analysis now supports larger scripts without freezing the SSMS/VS UI.
  • Limitation: Only the first 50,000 issues of code analysis are shown.

不具合の修正

• Do not show ST010 issue for CTE.
• PE010 shouldn't be triggered on a SELECT INTO statement.
• Don't detect BP014 issue on computed non persisted columns.
• BP014 Shouldn't apply to identity columns.
• "Place expressions on new line" under THEN expressions moves ELSE expression.