SQL Prompt 7

SQL Prompt 7.1 release notes

Version - March 8th, 2016


  • Support for SSMS 2016 RC0 / February 2016 preview

  • 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

Version - March 3rd, 2016


  • 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

Version - February 22nd, 2016


  • 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

Version - February 9th, 2016


  • 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

Version - January 26th, 2016

Results grid features

From the Results grid, you can now:

  • Copy results as an IN clause
  • Script results as an INSERT statement
  • Open results in Excel

To use these features, select some results in the grid, and right-click:

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

Highlight matching objects

When you place the caret on an object in a script, SQL Prompt now highlights all usages of that object:

If you want to change the highlight color, you can use the Management Studio functionality for customizing colors.

In Management Studio, go to Tools > Options > Environment > Fonts and Colors and select a new color for Brace Matching (Rectangle):

Highlight matching objects is an experimental feature and isn't on by default. To turn it on, go to Options > Experimental Features and select Highlight matching objects:

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)

The following are also now suggested:

  • Logins
  • Transactions
  • Columns from PIVOT/UNPIVOT clauses

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.

Environment support

You can now use SQL Prompt in SQL Server Management Studio January 2016 Preview (13.0.1000.281).

Other improvements and fixes

  • Support for using columns in self-joins with Qualify Object Names
  • You can now right-click to copy error messages from the database loading dialog boxe
  • Improved performance of column dependencies box
  • Reduced memory usage when previewing object creation scripts
  • IDENTITY columns are now recognised in table variables
  • Ambiguous column message is no longer displayed when running Qualify Object Names
  • Transactions can now be renamed with F2
  • You can now store SQL Prompt settings in AppData\Roaming

Didn't find what you were looking for?