CODEWITHSUNDEEP
sql-serverkeyboard-shortcutsssms
Stan
Stan

Reputation: 38255

SQL Server Management Studio execute shortcut & keyboard shortcuts

  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)?

Upvotes: 6

Views: 24807

Answers (5)

Kamilo
Kamilo

Reputation: 11

You can try this... You can use Alt + X and it should work just as CTRL + E

Upvotes: 1

Peffa
Peffa

Reputation: 141

@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.

Upvotes: 1

user2217078
user2217078

Reputation: 91

Alt + X. Global Execute shortcut.

Upvotes: 9

gbn
gbn

Reputation: 432200

  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

Upvotes: 12

Remus Rusanu
Remus Rusanu

Reputation: 294217

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

Upvotes: 1

Related Questions