What are the challenges you face when working across database platforms? Take the survey

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 - 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)
    • 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

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.


  • Options
    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
  • Options
    mdullni1mdullni1 Posts: 28 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.
  • Options
    Hi Both,

    You can either access them through the SQL Prompt menu:


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


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


    Best regards,

  • Options
    mdullni1mdullni1 Posts: 28 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.
  • Options
    Hi mdullni1,

    Are you talking about the SQL Prompt options window?


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


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



    Do please let me know if I'm misunderstanding.

    Best regards,

  • Options
    mdullni1mdullni1 Posts: 28 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.