I’ve had this code in a snippet for a long time:
I appreciate the markup to prevent SQL Prompt from doing this, which used to always happen.
I can’t tell you how many times I’ve used CTRL+Z to undo that format, add the markup, and format again.
A few months back. I was talking with someone and noticed this:
A new option for formatting called “INSERT”. This allows you to specify how you want to insert column list to appear. What’s even better, is at the bottom it says “Values”. Scroll down and you see options for separately formatting the VALUES clause, which I use all the time.
Now I can format easily without worrying my VALUES clause will get spread all over the page.
SQL Prompt is amazing. If you haven’t given it a try, download an eval today. If you have the Toolbelt, you ought to be using this every day.