用savepoint造句子，“savepoint”造句

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

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.

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.

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.

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

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.

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

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

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.

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

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

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.

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.