Vertical Select Mode feature in SQL Server Management Studio:
Vertical Select Mode trick itself is very simple—but very powerful (one of those things that can save you a lot of time (over time) if you know it well)—and rests solely in the ability to be able to select and change text on multiple lines by holding down the ALT key when selecting text.
Holding down the ALT and Shift Key allows you to select/modify text on multiple lines
Now if you want to select/Modify particular word in multiple lines then place cursor before the word and now hold alt key and mouse left key then drag on word column then it will select that particular word column in all rows now when you type any text then it will change in all rows for that column
this is nothing special or trick it’s just built-in editing feature in sql server, once you know about it and start to internalize and use it, it can be a nice productivity and boost your work productivity.
Thanks for reading this article if you like this article please share with your Friends.