SSMS: T-SQL Debugger Shortcuts August 30th, 2013

Vinod Kumar

Earlier this year I wrote about SQL Server 2012: Debugger basics. I felt that post had a lot of fun in the new debugger features. Having said that, this post can be seen as an continuation to the previous post. Here I call out all the shortcuts available with SQL Server Management Studio when it comes to using Debugger features.

As I write this, I would also want to know how many of you have used the debugger feature in your environments?

Action

Shortcut

Start or continue debugging

ALT+F5

Show next statement

ALT+NUM

Implement the Run To Cursor command

CTRL+F10

Display the QuickWatch dialog box

CTRL+ALT+Q

Toggle breakpoint

F9

Enable breakpoint

CTRL+F9

Stop debugging

SHIFT+F5

Step into

F11

Step over

F10

Step out

SHIFT+F11

Delete all breakpoints

CTRL+SHIFT+F9

Display the Breakpoints window

CTRL+ALT+B

Break all

CTRL+ALT+BREAK

Break at function

CTRL+B

Display the Watch 1 window

CTRL+ALT+W, 1

Display the Watch 2 window

CTRL+ALT+W, 2

Display the Watch 3 window

CTRL+ALT+W, 3

Display the Autos window

CTRL+ALT+V, A

Display the Locals window

CTRL+ALT+V, L

Display the Immediate window

CTRL+ALT+I

Display the Call Stack window

CTRL+ALT+C

Display the Threads window

CTRL+ALT+H

Display the Parallel Stacks window.

CTRL+SHIFT+D, S

Display the Parallel Tasks window

CTRL_SHIFT+D, K

This is interesting because SQL Server Management Studio is based out of Visual Studio shell and hence many Visual Studio shortcuts work inside SQL Server Management Studio too as you can see above. Do let me know if I missed out on any of the interesting shortcut for debugger.

Share this article

Tags: , , , , , , ,

This entry was posted on Friday, August 30th, 2013 at 08:30 and is filed under Technology. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply



 

Email
Print