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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s