Released: Apr 19, 2016
Updates in this release
Updates in 7.2.0.260
SSMS 2016 support
SQL Prompt now supports SSMS April 2016 Preview.
SQL Prompt 7.2 works with SSMS April 2016 Preview and SSMS March 2016 Preview Refresh, but won't work with earlier SSMS 2016 preview versions.
Execution warnings
SQL Prompt now shows a warning message when you try to execute an UPDATE or DELETE statement without a WHERE clause.
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) in Visual Studio
- 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
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
- Option added to exclude VALUES clause from auto-generated INSERT statements
- 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
