Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Feature Only in Enterprise Edition This feature is supported only in Visual C++ Enterprise Edition. For more information, see .
Once your SQL code has stopped at a breakpoint, you can step through the statements one statement at a time using the Step Into command.
To run the program and execute the next statement (Step Into)
While the SQL source is paused at a breakpoint, click Step Into from the Debug menu.
The debugger executes the next statement, then pauses execution. If the next statement is a nested procedure, the debugger steps into that procedure and pauses execution at the beginning of the procedure.
Repeat step 1 to continue executing the SQL code one statement at a time.
If you use this technique to step into a nested stored procedure, the debugger steps into the most deeply nested function. For example, assume the next line of code is:
EXEC return = stored_procedure param1, param2
The Step Into command causes the debugger to step into the called procedure stored_procedure and pause at the first line of execution.