Released: Apr 11, 2017

7.5 中的更新

特性

Updates in SQL Prompt 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 suggests the MIXED_PAGE_ALLOCATION option.
• Improvements to AT TIME ZONE suggestions.

修補程式

• SP-6189 Error starting Visual Studio if .NET 4.6 or newer is not installed.
• SP-6239 UPDATETEXT column must always be qualified with table name.
• SP-5960 No longer qualify ambiguous function names.
• SP-6083: Fix issue when getting suggestions for tables on a linked server.
• SP-6190: Fix crash on startup in Visual Studio 2017.
• SP-6170: Fix tab history compatibility issue in SSMS 2016.
• SP-6160: Fixed issue with missing suggestions in Visual Studio 2013.
• Fix for connection issue in some versions of Visual Studio.
• Fix issue when installing into Visual Studio 2017 without .NET 2.0 installed.