Released: Sep 26, 2018

Mises à jour de 9.3

Fonctionnalités

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

Released: Jun 27, 2018

Mises à jour de 9.2

Fonctionnalités

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

Correctifs

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

Released: Feb 21, 2018

Mises à jour de 9.1

Fonctionnalités

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

Correctifs

• 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

Mises à jour de 9.0.8

Fonctionnalités

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

Correctifs

• 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

Mises à jour de 9

Fonctionnalités

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

Mises à jour de 8.2

Fonctionnalités

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

Correctifs

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

Released: Sep 14, 2017

Mises à jour de 8.1

Fonctionnalités

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

Correctifs

• 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

Mises à jour de 8.0

Fonctionnalités

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

Released: Apr 11, 2017

Mises à jour de 7.5

Fonctionnalités

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

Released: Feb 16, 2017

Mises à jour de 7.4

Fonctionnalités

• Support for SQL Server Management Studio 17.
• Formatting improvements:
  • Improvements to BEGIN...END formatting.
  • Improvements to nested parentheses.
  • Case statements with comments now align correctly.
  • Now adds a space before aliases following function calls (forum).
  • Added "Place BEGIN keyword on new line" option.
• Azure Support
  • Visual Studio Azure connection support.
  • Azure active directory universal authentication support.

Correctifs

• Fix problem with Add/remove AS keyword in MERGE...