The ROLLBACK statement would fail with the error: Rollback to savepoint disallowed on updating an old server in same transaction.
ROLLBACK语句将失败并收到一个错误:保存点回滚不允许在同一事务中更新较旧的服务器。
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.
当回滚到事务中早先设置的保存点时,IDS将只回滚在设置保存点后由事务记录的所有操作。
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.
尽管不能输入新的订单,但是添加新客户的操作仍然通过了过程执行,并且通过在主事务中最后的保存点回滚完成了回滚。
In the case of an error, the transaction logic can specify that the transaction rollback to a savepoint.
在发生错误的情况下,事务逻辑可以指定该事务回滚到某个保存点。
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.
没有事务名称或保存点名称的ROLLBACK语句总是将语句回退到最外层的BEGINTRANSACTION(显式或隐式)语句,并且取消整个事务。
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.
没有事务名称或保存点名称的ROLLBACK语句总是将语句回退到最外层的BEGINTRANSACTION(显式或隐式)语句,并且取消整个事务。
应用推荐