Stepping Into SQL Source

  • Article

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)

  1. 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.

  2. 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.