SQL Server Management Studio execute shortcut & keyboard shortcuts

Question

1. Is there any easy way to execute a chunk of code instead of moving cursor to the beginning of code chunk, and Shift + ↓ to the end of code, then hit F5?

2. Is there any keyboard shortcut to duplicate line (duplicate several lines), delete line (delete several lines)?

Solution 1

1. No, but CTRL+E is also "Execute" which is what I use which might be easier

2. No, but you may be able to find something in all SSMS KB shortcuts on MSDN. Example: shift+down arrows, ctrl+C, ctrl+V x 2

Solution 2

Alt + X. Global Execute shortcut.

Solution 3

@Keyboard short cut to copy a line

CTRL + C -- Note there is no need to select the line, use the shortcut with the cursor anywhere on the line & the whole line will be copied.

E.g. CTL+C, CTL+V --will copy the current line & paste it in the next line.

Solution 4

You can check out the SSMS Tool Pack as it has some features around SQL snippets and execution.

View more solutions