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

Aaron L

SQL Prompt 7.3.0.775 - 5th December 2016

This build of SQL Prompt includes:

• New Format SQL experimental feature
  • The formatting is now more customisable
  • More options for:
    • CASE (UserVoice)
    • JOIN (UserVoice)
    • CTEs (UserVoice)
    • CREATE statements
    • IN expressions
    • And many more (UserVoice, UserVoice, UserVoice, UserVoice, UserVoice, UserVoice, UserVoice)
  • You can now store your styles in a shared folder to have a consistent style across your team
  • Create multiple styles and switch between them easily (UserVoice, UserVoice)
  • Disable formatting within the script using SQL comments (UserVoice)
• 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.

gerhau

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.

mdullni1

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.

David Priddle

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,

David

mdullni1

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.

David Priddle

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,

David

mdullni1

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.