Commit after each statement |
Continue |
If a statement is successful, it is committed
to the specified database. If an error occurs, the next statement
will run. |
Commit after each statement |
Stop |
If a statement is successful, it is committed
to the specified database. If an error occurs, the script will stop
running. |
Commit on completion of script |
Continue |
If all of the statements in the script are successful,
all statements are committed to the specified database. If an error
occurs, the next statement will run, and all successful statements
are committed to the specified database. |
Commit on completion of script |
Stop and Commit |
If all of the statements in the script are successful,
all statements are committed to the specified database. If an error
occurs, the script will stop running, and any statements that were
successfully run are committed to the specified database. |
Commit on completion of script |
Stop and Roll Back |
If all of the statements in the script are successful,
all statements are committed to the specified database. If an error
occurs, the script will stop running, and all successful statements
are rolled back. |
Roll Back on completion of script |
Continue |
If all of the statements in the script are successful,
all statements will be rolled back. If an error occurs, the next statement
in the script will run, and any successful statements are rolled back. |
Roll Back on completion of script |
Stop and Roll Back |
If all of the statements in the script are successful,
all statements will be rolled back. If an error occurs, the script
will stop running, and all successful statements are rolled back. |