Menu
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?
Is there any keyboard shortcut to duplicate line (duplicate several lines), delete line (delete several lines)?
617
F5 or Ctrl + E -- Execute a query. F1 -- Help for Query Analyzer. SHIFT+F1 -- Help for the selected Transact-SQL statement.
At the top of the screen is a toolbar containing lots of buttons. One of those buttons is labeled New Query, and when you click on it you open a window in which you can type and execute SQL. You'll be using this button and window extensively.
Typing CTRL+L executes either the selected text in the Query Editor window (or all the statements in the window if nothing is selected) and displays the execution plan.
No, but CTRL+E is also "Execute" which is what I use which might be easier
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
155
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
