In SQL Prompt 8.2 we have added a new section within the formatting options where you can manage how column and values lists are displayed.
In SQL Prompt 8.1 we have introduced a brand new way to manage your parenthesis options when setting up your formatting styles.
You have told us you want more specific control over how you want your brackets to appear, such as on new lines, indented and aligned to different objects.
Under the Global settings in the Custom Style screen you can find the new options in the Parenthesis section.
Simply select the style you want to use from the nine options available.
You can also set your parenthesis style for
ALTER statements by going to Statements and then the Schema (DDL) section. Here you can again choose the style you want to use from nine options available:
And you can also choose the style of your parenthesis within CTE contents:
SQL Prompt 8 includes our brand new formatting engine. You can finely tune your formatting style, save multiple styles, share with others and quickly switch between them.
This guide will help you get started formatting your code with SQL Prompt 8.
We've added many new formatting options based on your feedback, including:
Plus, we've added support for Support for SSMS 2017 and Visual Studio 2017.