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

Share

Share

Rate