After we released SQL Prompt 8, our priority was to continue to support the new formatting engine by fixing any bugs and reviewing feedback from users.
One of the recurring patterns we noticed in your feedback regarded parentheses formatting. Some of you told us you couldn’t format the parentheses exactly the way you wanted to.
We also heard that many of you were having trouble understanding how the different parentheses options worked and, in some cases, how they could be combined to get different results.
This was how we originally displayed parenthesis options:
8.0 parentheses options
And this is how we have updated parenthesis options in SQL Prompt 8.1:
8.1 parentheses options with indent selection preview (GIF)
As you can see, we’ve given you more options to format your parentheses, while at the same time making it easier for you to decide which option to choose to get the desired results.
We created a brand new parenthesis UI with a much more visual way of providing you with options. This new method allows you to identify which options best fits your needs at a glance.
We spoke to many of you to discuss your parenthesis requirements in more detail. From those calls, we’ve developed nine styles from which you can choose your particular formatting need.
One cool new feature we’ve added that was suggested during development was for the Indent parentheses button to make visual changes to the parentheses selection buttons. You can see this in action in the GIF above.
We’ve made these parenthesis options available in the places you need to format them. In the Custom Style screen you can find the new Parenthesis options within Global settings. You can also find parenthesis options available under the Schema (DDL) and CTE within Statements settings.
We hope these new parenthesis formatting options help you when setting up your style. You can get them right now by upgrading to SQL Prompt 8.1.
Also in Hub
Using TOP in a SELECT statement without a subsequent ORDER BY clause is legal in SQL Server, but meaningless because asking for the TOP 10 rows implies that the data is guaranteed to be in a certain o...
Also in Product learning
People can, and do, argue a great deal about the relative merits of table variables and temporary tables. Sometimes, as when writing functions, you have no choice; but when you do you’ll find that b...
Also in SQL Prompt
The MONEY data type confuses the storage of data values with their display, though its name clearly suggests the sort of data it holds. It is proprietary to SQL Server and allows you to specify moneta...
Also about SQL Prompt
When writing functions or procedures, a common chore is to devise and implement the tests that ensure that the routine always works as expected. The best way to do this is to define the tests in a bat...