SQL Prompt Pro 新版本發表

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

Released: May 19, 2016

Updates in this release

Updates in

  • Fix for incorrect $CURSOR$ placeholder location in the 'curff' default snippet
  • SP-5694: Fix for null reference exception being thrown on invalid computed column syntax

Released: Apr 27, 2016

Updates in this release

Updates in 7.2.1267

  • Execution warnings are no longer shown when modifying an aliased temp table
  • Format SQL is now included in the right click context menu in SSMS2016
  • Fix for issue with high-DPI mode in SSMS2008R2 under Windows 8.1 and 10
  • Fix for wildcards not expanding on certain scripts
  • Support ticket 65031: Fix for tab history not restoring tabs if nosplash argument is passed to SSMS on the command line