Thursday, April 10, 2014

Break points in SQL Server

TOGGLE A BREAK POINT
Press F9.

To open the breakpoints window
Press CTRL+ALT_B

To RUN the query/execute the store procedure
Press ALT+F5

Sample break point example below:


Move from one break point to another: Right click on the query window and select ‘Run To Cursor’