Format SQL - quick styles
I want to switch between TEAM and PERSONAL styles for Format SQL. It currently takes 8 mouse clicks to achieve this. Could you add a style lookup on the context menu or Red Gate tools menu and apply the style to the current document automatically as soon as it is selected.
I want my team to be able to work in their personal SQL format, but always save in the TEAM format.
This feature is now included in the new SQL Prompt 8.0. For additional information see: http://documentation.red-gate.com/display/SP8/SQL+Prompt+8.0+release+notes
You can get the latest version of SQL Prompt from http://www.red-gate.com/products/sql-development/sql-prompt/
Thank you for your help!
Bill Hoenig commented
I like this concept a lot. I think I'm just restating the suggestion here, but just for clarification, I would like to see a "Format SQL as -->" in the SQL Prompt menu and in the submenu, there would be my various defined styles. This would be a huge win because many times I want my own code formatted differently base on the content and purpose of the query. For example my larger queries, I want to be more formally structured. But when I debugging and writing multiple small queries, I want them to be more compressed so that I see them all on the same page.
Lawrence Barnes commented
This is a similar request to: http://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/7016721-shortcut-for-switching-styles