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

Latest stable build of SQL Prompt is 7.3.0 (5th December)

Aaron LAaron L Posts: 596 New member
edited December 20, 2016 8:40AM in SQL Prompt
SQL Prompt 7.3.0.775 - 5th December 2016

This build of SQL Prompt includes:
  • New Format SQL experimental feature
  • Inline EXEC (UserVoice, UserVoice)
  • New options to control when execution warnings are shown:
    • Statements with an INNER JOIN (UserVoice)
    • Scripts that create or alter a procedure or trigger (UserVoice)
    • TRUNCATE statements
  • Format actions for aliases
    • Add/remove AS keyword on alias definition for tables and views (UserVoice)
    • Apply column alias style (UserVoice)
  • Variables are now declared automatically for OUTPUT parameters when generating an EXEC statement (UserVoice).
  • Support for SQL Server 2016 SP1 syntax:
    • CREATE OR ALTER (UserVoice)
    • DBCC CLONEDATABASE
    • USE HINT query hint
  • User account licensing (More information)
  • Support for Azure Active Directory Integrated authentication and Azure Active Directory Password authentication (UserVoice)
  • Many other improvements and fixes

Download this release

Full release notes

Feedback
If you find any issues 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.

Comments

  • Hi. Exactly where are these new features located in the options-window?
    i.e the new options for CASE-statements..? I can't seem to find them.
    Gert Hauan
  • mdullni1mdullni1 Posts: 26 Bronze 3
    The Experimental Feature 'Use new formatting styles' only provides right alignment, which I want. However, the other formatting options disappear. I would like the alignment feature in addition to the other features.
  • Hi Both,

    You can either access them through the SQL Prompt menu:

    Qkq9oYl.png

    Or by clicking on the Edit styles link on the experimental features page of the SQL Prompt options window:

    z39nJu2.png

    Or by clicking on Edit Styles in the right-click context menu when writing SQL:

    eLmJabn.png

    Best regards,

    David
  • mdullni1mdullni1 Posts: 26 Bronze 3
    I believe you misunderstood my post. When I select "Use new formatting styles" in Experimental Features, the Styles options disappear from the main menu, so the only formatting I have is right-aligned.
    I can post an image if you tell me how.
  • Hi mdullni1,

    Are you talking about the SQL Prompt options window?

    hAfELnd.png

    If so, once you turn on the experimental formatter you have to edit the style through the Edit formatting styles:

    KLDoWUr.png

    If you click on Edit style, you'll get all of the options once you've picked a name for the new style:

    uQeX9rd.png

    RhcPLqa.png

    Do please let me know if I'm misunderstanding.

    Best regards,

    David
  • mdullni1mdullni1 Posts: 26 Bronze 3
    Thank you for this detailed explanation. It was not apparent that I had to name the editing style before the editing choices were displayed. It just said More to Come.
Sign In or Register to comment.