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.

Released: Dec 11, 2017

9 での更新項目

機能

New code analysis provides fast and comprehensive analysis of T-SQL code in SSMS and Visual Studio.

• Discover over 80 code issues and hidden pitfalls as-you-type.
• Get clear explanations and suggestions to improve your code.
• Choose from a large selection of analysis rules and manage which ones are displayed.

Released: Oct 4, 2017

8.2 での更新項目

機能

• Added support for most new SQL Server 2017 syntax, including:
  • Added support for new Graph Table syntax.
  • New SET IDENTITY_CACHE option for ALTER DATABASE SCOPED CONFIGURATION.
  • New syntax for online resumable ALTER INDEX statements.
  • Added support for new SELECT INTO .. ON Filegroup syntax.
• Added new INSERTS page with formatting options for both the column and values lists.

不具合の修正

• SP-6617 : Fix 'Align items across clauses' option not aligning to JOIN tables.
• SP-6626 : Fix AS keywords not...

Released: Sep 14, 2017

8.1 での更新項目

機能

• Overhauled parenthesis style options UI to improve usability and remove possibility of unusual styles.
• The Parentheses, DDL and CTE pages now have a new way to choose the style of your parentheses.

不具合の修正

• SP-6450 : No longer fail when formatting of valid selection.
• SP-6604 : Fix missing whitespace near AS clause when formatting TRY_CAST statement.

Released: May 10, 2017

8.0 での更新項目

機能

• Improved Formatting options.
  The formatting styles are now much more customizable. Added new options based on customer feedback including:
  • Add options for CASE WHEN ELSE END.
  • Disable SQL Prompt on certain blocks of code.
  • Quick switching between styles.
  • Indent comments consistent with code.
  • Support a common intending option for SELECT.
  • Expose all formatting options in the UI.
  • Format common table expressions (CTEs).
  • Simple, but toggle indenting of else if statements.
  • Column aliases alignment...

Released: Apr 11, 2017

7.5 での更新項目

機能

• Add support for SQL Server 2016's WITHOUT_ARRAY_WRAPPER.
• Support for Visual Studio 2017.
• Formatting improvements:
  • ON and WHEN keywords in MERGE statements can now be right-aligned.
  • ELSE IF statements are now indented the same as IF statements.
  • Fix for error when formatting some server broker statements.
  • Short ALTER TABLE statements now respects the 'Collapse Short DDL statements' option.
  • Fix issue with parenthesised expressions sometimes removing spaces between keywords.
• SQL Prompt now...