I work for Redgate and write about products. I’ve got a series of SQL Prompt posts here on little things I like. SQL Prompt might be my favorite tool. SQL Prompt will be yours as well if you give it a try.
I thought this would work, but I wasn’t sure. I saw some code the other day like this:
I dropped it into SSMS, and of course, I couldn’t read much of it. I did a quick CTRL+K, CTRL+Y and it looked like this:
Yeah, SQL Prompt. In addition to reformatting as I prefer, it removed the extra whitespace.