views:

266

answers:

2
  1. Is there any easy way to execute a chunk of code instead of moving cursor to the beginning of code chunk, and shift + down arrow 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)?

Thanks.

A: 

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

Remus Rusanu
+1  A: 
  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

gbn