“savepoint”可以造什么句，savepoint造句

2、On rolling back to a savepoint, all the logged temp tables - data and schema - are restored to their states prior to setting the savepoint.

4、Any reference to a released savepoint is invalid and results in an error.

6、The ROLLBACK statement would fail with the error: Rollback to savepoint disallowed on updating an old server in same transaction.

8、When used, the statement rolls back the part of the transaction that occurred after the savepoint identified by svpt1.

10、If the available quantity from the stock table for the requested item is less than the quantity ordered, the transaction rolls back to the neworder savepoint.

12、This also means that you can refer to a savepoint only in the same execution of a procedure, but not from another execution of the same or other procedures irrespective of the nesting level.

1、When a transaction rolls back to a savepoint, all non-hold cursors opened after that savepoint are closed.

5、Therefore, a savepoint name needs to be unique only in its scope of execution.

9、Procedure calls can be nested or recursive, but the scope of a savepoint is restricted to the execution of the stored procedure in which it is defined.

13、Although the new order cannot be entered, the new customer addition still passes with the procedure execution, and is rolled back with the final rollback to savepoint in the main transaction.

7、Cannot go remote while the session is enlisted in a distributed transaction that has an active savepoint.

3、When you rollback to a savepoint set earlier in a transaction, IDS just rolls back all the operations logged by the transaction after the savepoint was set.

11、ROLLBACK statement without a transaction or savepoint name always rolls back statements to the outermost BEGIN transaction (explicit or implicit) statement, and cancels the entire transaction.