Options
Formatting Help
JesseT
Posts: 3
Hello,
Would anyone who's an expert in setting the SQL Prompt Format options help me figure out how to do this? I'm trying to set the formatting for insert into myTable (column1, column2) select column1, column2 from myOtherTable. No matter what settings I choose I can't seem to make the formatting for the insert match the select. The columns in the select will line up nice with a preceeding comma and tab. The columns in the "insert" part don't seem to follow any formatting options.
Any help on how to format the columns in the top part of the insert statement below would be much appreciated.
Would anyone who's an expert in setting the SQL Prompt Format options help me figure out how to do this? I'm trying to set the formatting for insert into myTable (column1, column2) select column1, column2 from myOtherTable. No matter what settings I choose I can't seem to make the formatting for the insert match the select. The columns in the select will line up nice with a preceeding comma and tab. The columns in the "insert" part don't seem to follow any formatting options.
Any help on how to format the columns in the top part of the insert statement below would be much appreciated.
Comments
If I’ve followed your description correctly then unfortunately this is not currently possible to do in SQL Prompt. However, we are in the middle of overhauling SQL Prompt’s formatting engine to accommodate a much wider range of formatting styles.
It’d be really useful to us if you could fill out our formatting options survey:
https://www.surveymonkey.com/r/?sm=cvYX ... xkqA%3d%3d
(You can fill it out as many times as you want)
Thanks
Ali
Thank you for your response and as you have suggested I've completed the survey with an example of the formatting for "Insert" statements that would be very nice to have. I'll continue to add any other formatting tweaks that would be nice to add to the SQL Prompt tool as they are discovered.
Thanks,
Jesse