Blog Post

Quick tip: Quickly bulk edit lines in SSMS

,

Have you ever needed to bulk edit a table from excel to change it into a group of insert statements or change multiple query lines?

In SQL Server Management Studio (SSMS) you can use SHIFT+ALT+[up/down arrow] to bulk edit lines. Note that this key-combo in Azure Data Studio adds a new line so the functionality isn’t the same.

Note that you can always use CTRL-H to find/replace text; but, it’s nice to have options.

Here’s a look at SHIFT+ALT+UPARROW and SHIFT+ALT+DOWNARROW in action.

multiline1

multiline2

Original post (opens in new tab)
View comments in original post (opens in new tab)

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating