Maximize the power of SQL Prompt with SQL Toolbelt Essentials. Watch now.

SQL Prompt 7.0.0.62

Aaron LAaron L Posts: 596 New member
edited August 19, 2015 5:21AM in SQL Prompt
SQL Prompt 7.0.0.62 - 22nd September 2015

This build of SQL Prompt includes:
  • Visual Studio 2015 support
    The following features are now available in Visual Studio 2012 or later:
    • Find invalid objects
    • Script as ALTER
    • Execute current statement
    • Rename variables/aliases
    • Encapsulate as new stored procedure
    • Split table
  • Management Studio 2016 CTP2 support
  • User placeholders in snippets (UserVoice)
  • Tab coloring improvements (Blog post)
  • Actions list to refactor selected text. The actions list includes:
  • Find invalid object improvements (UserVoice)
  • Suggestions improvements:
    • Filegroups are now suggested and casing options are applied to them when you format
    • Support for new FOR JSON clause
    • Global variables are no longer suggested for assignment
    • Indexes are now suggested for table hints
    • MERGE statement suggestions improved (Uservoice)
    • Full suggestions for cross-database queries are disabled if a schema exists with the same name as the database (Forum post)
    • Windows users and groups are now suggested for GRANT statements (UserVoice)
  • Many other improvements and fixes
Download this release

Full release notes

Feedback
If you have any problems with this release, please post them on this forum.

If you have any suggestions for improvements, please post them on our suggestions forum so other users can vote for them.

Version history
7.0.0.62 - 22nd September
  • Fix for error message "a column with that name exists in multiple tables" when using qualify object names on an UPDATE FROM (Forum post)
7.0.0.60 - 21st September
  • Added option "Show actions list for selected text"
  • Improved wildcard matching order for Tab Coloring
  • Open tabs are now marked as closed in Tab History if SSMS crashes and the "Reopen tabs when SSMS starts" option isn't selected
  • Fix for DOUBLE PRECISION being fomatted incorrectly (Forum post)
  • Fix for SP-5519: NullReferenceException being thrown when inserting certain snippets
7.0.0.52 - 8th September
  • Improved performance when inserting large snippets
  • Fix for missing aliases when completing a join suggestion (Forum post)
  • Action list is no longer shown after using Ctrl+click to select a word (Forum post)
  • Add square brackets no longer adds brackets around $action in MERGE statements (Forum post)
  • Suggestions are now displayed when an alias could be defined if there's a new line between the caret and the table/view name (Forum post)
  • Fix for square brackets not being added to an index that requires them in a DROP INDEX statement
  • Completing an index name in DROP INDEX will only auto-complete the ON part if the index is unqualified
7.0.0.49 - 2nd September
  • Ambiguous columns in UPDATE statements now have qualification added on completion
  • Serial number on about dialog box is now readable with high DPI displays
  • Enable suggestions menu item no longer changes text (Forum post)
  • Error dialog is no longer displayed for a failed login due to "<multiple>" database
7.0.0.43 - 26th August
  • Support ticket 48742: Fix for error message "An item with the same key has already been added" with snippets containing two user placeholders that only differ by case
7.0.0.41 - 24th August
  • Multiple $SELECTEDTEXT$ snippet placeholders can now be used on a single line (Forum post)
7.0.0.40 - 19th August
  • Fix for built in status strip coloring not being changed when the connection has changed
7.0.0.39 - 18th August
  • Initial release
Sign In or Register to comment.