How to Put SQL Column Names Onto Multiple Lines in SSMS

Опубликовано: 29 Октябрь 2024
на канале: Bert Wagner
1,681
36

It's annoying when you copy and paste a query from somewhere and all of the columns in the SELECT statement are all on the same line.

Today we look at how to format this single line of column names into multiple lines in SQL Server Management Studio, WITHOUT using any special plugins or tools.

Original blog post: https://blog.bertwagner.com/how-to-pu...

Want to receive the latest weekly blog posts and videos in your inbox? Sign up for the newsletter here: https://upscri.be/c77fc8/

Elsewhere on the internet:
https://blog.bertwagner.com
  / bertwagner  

Major thanks to Bryce from Skyview Plaza for recording the sweet opening metal guitar riff. Check out his band:   / skyviewplazamusic  

NEED YOUR HELP: this feature (along with other RegEx find/replace queries) is broken in SSMS 2017. Please vote up this Connect item to make sure Microsoft fixes it before 2017 is officially released https://connect.microsoft.com/SQLServ...