Wednesday , October 17 2018
Home / DataBase / SQL SERVER / Vertical Select Mode feature in SQL Server Management Studio

Vertical Select Mode feature in SQL Server Management Studio

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

multiselect

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

multiselect-mouse

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.

Print Friendly, PDF & Email

Give us your valuable feedback

comments

About Murali

Hello everyone I am Software Developer having 3+ years of Experience in Microsoft Technologies and Others. My skills :- Asp.net, C#,Ado.net, SQL SERVER, web services, windows Service,Windows applications,HTML,CSS, JavaScript,JQuery,AnjularJs

Check Also

sql server backup script

Backup all databases in SQL Instance with one script

Backup: A copy of SQL Server data that can be used to restore and recover the …