Implicit Transactions are those that requires a COMMIT or ROLLBACK for every transaction.
When ON, SET IMPLICIT_TRANSACTIONS sets the connection into implicit transaction mode. When OFF, it returns the connection to autocommit transaction mode.
For example if we turn it on & update a table, the changes will not be committed until COMMIT command is executed.
No comments:
Post a Comment