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.
  • Moving commas from "end" to "start" is always buggy when comments exist.
  • Remove extra space between statements option is needed.
  • Line up type declarations.
  • Place semicolon on new line.
  • Option to place Table names on the same line as the keyword.
  • Do not indent FROM and WHERE clauses.
  • Merge command formatting options.
• Support for SSMS 2017 and Visual Studio 2017.
• Added basic support for connecting to SQL Server 2017
• SP-6253 Type column overlayed
• SP-6330 INLINE EXEC chops off END when sproc body is wrapped in BEGIN/END
• SP-6213 Format exec parameters as insert source
• SP-6340 Formatting/multiple collapse interaction
• SP 6334 SQL Prompt 8 have issues formatting options HAVING BETWEEN
• SP-6268 New option to insert table on new line
• SP-6342 Comments swapping on same line
• Allow renaming styles in edit mode
• SP-6365 : Nested clause indent support (Insert/select statement).
• SP-6348 : Indent body of create view.
• SP-6361 : Add support for 'ALTER DATABASE SCOPED CONFIGURATION'.
• SP-6362 : Format 'CREATE VIEW' columns correctly.
• SP-6356 : Column list indent and 'Align items across clauses' not working always.
• SP-6352 : 'Collapse short DML statements' option not working with some WHERE breaking combinations.

Please note that this release no longer supports SSMS 2008 R2 or earlier versions.

不具合の修正

• SP-6338 Fix where condition in parenthesis not breaking.
• SP-6335 Fix right align where exists.
• SP-6250 Fix Active Directory Universal authentication.
• SP-6321 : Fix for 'Invalid name character in Workstation ID' issue.
• SP-6345 : Fixed DB population of a SQL2005+ linked server when running in a SQL 2000 environment.
• Prevent crash when user attempts to rename to same style name.
• Prevent file overwrites when using invalid path characters in style names during style renames.