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

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

Released: Feb 16, 2017

7.4 中的更新

特性

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

修補程式

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

Released: Dec 5, 2016

7.3 中的更新

特性

• Improved SQL formatting - includes a new experimental version of the Format SQL feature, the formatting styles are now much more customizable.
• Added more options for formatting CASE statements, JOINs, CTEs, CREATE TABLE statements, IN values, and more.
• Easier to:
  • Create your own style by using one of the new built-in Redgate styles as a starting point.
  • Share your formatting styles with other SQL Prompt users by storing them in a shared folder.
  • Create multiple formatting styles and switch...