Use "step mode" to execute your batch SQL script one SQL command at a time.
To use the Step Mode feature:
- From the
Query menu, click the
Current Query Options command.
SQLWizard displays the Query Options dialog box.
- Select the
All Commands option in the
Execute group box. This option ensures that the entire script is executed at run time.
- Click
OK.
- From the
Query menu, click
Step Mode.
- Follow the steps described in
Running a Script to run your batch SQL script.
SQLWizard steps through the script one SQL command at a time, and displays the results of each command in a separate Result
window.