These pages cover SQL Prompt 7, which is not the latest version. Help for other versions is also available.

Skip to end of metadata
Go to start of metadata

Version 7.2.4.291 - June 22nd, 2016

  • Select in Object Explorer now sets keyboard focus to the Object Explorer (Forum post)
  • Select in Object Explorer now clears filters if they are hiding the object being selected (Forum post)
  • Support ticket 67549: Fix for variable being incorrectly cased as a parameter with the same name in EXEC statement
  • Support ticket 67974: Fix for geometry being incorrectly cased when using geometry's static methods
  • Support ticket 68061: Fix for Open in Excel displaying a warning with high precision scale/precision decimals
  • Updated SQL Prompt logo

Version 7.2.3.283 - June 8th, 2016

  • Support ticket 67262: Fix for rename alias/variable inside OVER clauses not working
  • Support ticket 66354: Fix for actions list not being displayed when word wrap is enabled
  • Fix for table variable being surrounded by square brackets when being passed to a function (Forum post)
  • Provide feedback links now open feedback form

Version 7.2.2.273 - May 19th, 2016

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

Version 7.2.1.267 - April 28th, 2016

  • 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 (Forum post)
  • Fix for wildcards not expanding on certain scripts (Forum post)
  • Support ticket 65031: Fix for tab history not restoring tabs if nosplash argument is passed to SSMS on the command line

Version 7.2.0.260 - April 19th, 2016

SSMS 2016 support

SQL Prompt now supports SSMS June 2016.

Execution warnings

SQL Prompt now shows a warning message when you try to execute an UPDATE or DELETE statement without a WHERE clause (UserVoice):


Warnings aren't shown when modifying temporary tables or table variables.

Suggestions improvements

  • SQL Prompt now offers suggestions when connected to Azure SQL Data Warehouse and Analytics Platform System (formerly known as Parallel Data Warehouse, or PDW) (UserVoice)
  • Improved suggestions performance
  • Additional SQL Server 2016 built-in functions are now suggested: COMPRESS, DECOMPRESS, SESSION_CONTEXT and DATEDIFF_BIG
  • Additional SQL Server 2016 DBCC statement syntax is now suggested
  • The initial connection to a server is now made asynchronously
  • NEWNAME is now suggested as an option for ALTER DATABASE MODIFY FILE (UserVoice)
  • Column names are now suggested even if the definition for their data type can't be retrieved (Forum post)

Other improvements and fixes

  • Highlight Matching Objects experimental feature is now enabled by default
  • Open in Excel from the Results grid now exports NULLs as blank cells (UserVoice)
  • Option added to exclude VALUES clause from auto-generated INSERT statements (UserVoice)
  • Script as INSERT and Open in Excel now support reordered Results Grid columns
  • Script as INSERT and Copy as IN Clause now use non-unicode strings for char and varchar data types
  • Find Invalid Objects now performs additional validity checks for table-valued functions
  • Fix for missing remote_data_archive_migration_state column when using Smart Rename or Split Table
  • Expand wildcards now inserts a space before the first column name if needed
  • Support ticket 63511: Results grid features now support exporting high precision/scale decimals
  • Support ticket 63041: Correct columns are now suggested in a MERGE statement's INSERT clause
  • No labels