Released: Mar 8, 2016

Updates in this release

Updates in 7.1

Features
These features are available in Management Studio and Visual Studio 2012 and later.

• From the Results grid, you can now:
  • Copy results as an IN clause
  • Script results as an INSERT statement
  • Open results in Excel
• Highlight matching objects - When you place the caret on an object in a script, SQL Prompt now highlights all usages of that object.

Suggestions improvements
SQL Prompt now offers suggestions for the following SQL Server 2016 syntax:

• Row-level security (MSDN)
• Dynamic data masking (MSDN)
• Always encrypted (MSDN)
• Stretch tables (MSDN)
• System versioning (MSDN)
• Query store options (MSDN)
• JSON functions (MSDN)
• DROP IF EXISTS

The following are also now suggested:

• Logins
• Transactions
• Columns from PIVOT/UNPIVOT clauses
• Constraints for ALTER TABLE/DROP CONSTRAINT

Variables are also now suggested in more statements.

Tab history improvements

• You can now disable tab history
• Tab history now includes a Closed tab: If you launch Management Studio by opening a script from SQL Compare, your open tabs aren't automatically restored.

Fixes

• Support for SSMS 2016 RC0 / February 2016 preview
  (Known issue: If you have SQL Test or SQL Dependency Tracker installed, SQL Prompt may not offer suggestions in SSMS 2016 RC0. If you encounter this issue, you'll need to uninstall SQL Test and SQL Dependency Tracker to use SQL Prompt. This issue should be fixed in the next releases of SQL Test and SQL Dependency Tracker.).
• New SQL 2016 RC0 built-in functions are now suggested: STRING_SPLIT, STRING_ESCAPE and JSON_MODIFY.
• Support ticket 61581: Timestamps are now supported in more localizations when using "Open in Excel" from the Results grid.
• Using "Script as INSERT" from the Results grid now includes the size/scale/precision for more data types.
• Fix for square brackets being added around the exponent when using scientific notation.
• Fix for column names in table value constructors being incorrectly qualified.
• Support ticket 59838: The "Specify Values for Template Parameters" form is now shown on completing a snippet if template parameters are used alongside the $SELECTEDTEXT$ snippet placeholder.
• Support ticket 59835: When using "Open in Excel" from the Results grid, dates before 1900 are now exported as strings due to date limitations in Excel.
• SP-5695: Wildcards qualified with a table synonym are now expanded correctly.
• SP-5074: Fix for "Input string was not in a correct format" error message being displayed when importing an old options file.
• SP-5706: Fix for a NullReferenceException being thrown with PIVOT/UNPIVOT clauses in some context.
• Support ticket 59626: Additional property names are now suggested for the SERVERPROPERTY function.
• Support ticket 58618: Suggestions are now offered when connected to a SQL server hosted on the Aliyun Cloud platform.
• SP-5695: Wildcards qualified with a table synonym are now expanded correctly.
• SP-5648: Fix for a COM exception being thrown when copying from Results grid if another program has a lock on the clipboard.
• SP-5513: Fix for a WPF exception being thrown if the windir environment variable is incorrectly set.
• SP-5401: Fix for an exception being thrown by tab coloring menu items on the registered servers window after server has been removed.
• SP-5385: Fix for a NullReferenceException occasionally being thrown on shutdown.