Ability to quickly switch SQL formatting styles.
We need the ability to quickly switch between T-SQL Formatting styles.
I work on a team where everyone likes code formatted differently. Also, we're required to use a specific format before checking SQL Code into TFS. I need a quick way to switch between styles so I can code in a format I like and then switch to our standard before check-in. Toad already offers this.
Version 8.0 of SQL Prompt allows you to quickly switch between formatting styles by clicking SQL Prompt → Active Style → (the style you’d like).
You can get the latest version of SQL Prompt from https://www.red-gate.com/products/sql-development/sql-prompt/.
If there is something missing please let us know by opening a new suggestion.
The Prompt Team
Thomas Franz commented
good solution, but you should apply it either to SQL Prompt | Options | Tabs | Color | Edit environments or give the user another way to define the default style at database level (when you have multiple projects and they use different styles)
Andrew Hartley commented
I would be able to enforce a team style if we had this feature, which would make comparing versions to see changes a lot easier.