Option to unformat onto a single line
Often when I'm debugging code that dynamically generates SQL, I hit a breakpoint, then copy the code into an SSMS query window. All the code is typically in a single long line. I can then use SQLPrompt to format the code to read it, and potentially change it to correct errors. However, what I then often want to do is to paste the changed code back into the variable (or whatever). I'd love to be able to have an option to format the code all into a single line.
6
votes
Greg Low
shared this idea
This is included in SQL Prompt 7 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/