The procedure sets a savepoint named neworder.
该过程设置了一个名为 neworder 的保存点。
You can use all of the savepoint statements within stored procedures.
您可以在存储过程中使用所有保存点语句。
Any reference to a released savepoint is invalid and results in an error.
引用已释放的保存点是无效的，并导致一个错误。
Therefore, a savepoint name needs to be unique only in its scope of execution.
因此，保存点的名称只需在其执行范围内保持惟一。
If there is an error, the program rolls back the transaction to the neworder savepoint.
如果出现错误的话，程序将把事务回滚到neworder保存点。
The number of requests for a storage engine to place a savepoint.
存储引擎放置一个保存点的请求数。
The number of requests for a storage engine to roll back to a savepoint.
存储引擎回滚到一个保存点的请求。
In the coming SQL3, the concepts of savepoint and partial rollback are specified.
在即将推出的SQL3中，明确了保存点和部分回滚的概念。
Setting another savepoint named newcustomer with the UNIQUE keyword results in an error.
使用UNIQUE 关键字设置另一个名为newcustomer 的保存点将生成一个错误。
Rolls back a transaction from a pending state, and specifies the transaction or savepoint name.
从挂起状态回滚事务，并指定事务或保存点名称。
This rollback undoes all the operations that were performed after the neworder savepoint was set.
这个回滚将撤销在设置 neworder 保存点之后执行的所有操作。
The code sets a savepoint with the same newcustomer name as the savepoint set inside the procedure.
代码设置了一个与过程内部设置的保存点同名的newcustomer保存点。
In the case of an error, the transaction logic can specify that the transaction rollback to a savepoint.
在发生错误的情况下，事务逻辑可以指定该事务回滚到某个保存点。
When used, it specifies that this is meant to be a unique savepoint within the scope of the current transaction.
在使用时，它表示该保存点是当前事务范围内惟一的保存点。
When used, the statement rolls back the part of the transaction that occurred after the savepoint identified by svpt1.
当使用该语句时，将回滚到发生在svpt1 保存点之后的操作。
On rolling back to a savepoint, all the logged temp tables - data and schema - are restored to their states prior to setting the savepoint.
在回滚保存点时，所有已登录的temp表—数据和模式—都被恢复到设置保存点之前的状态。
If a savepoint with the same name that is specified for svpt1 already exists in the same transaction, this statement generates an error.
如果同一个事务中已经存在一个和svpt 1同名的保存点，那么该语句将生成一个错误。
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.
过程调用可以是嵌套的或递归的，但是保存点的范围被限制为定义它的存储过程的执行。
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将只回滚在设置保存点后由事务记录的所有操作。
The example in Listing 11 connects to a local database named ldb, sets savepoints, performs operations on remote databases, and rolls back to a savepoint.
清单11中的示例连接到一个名为ldb 的本地数据库，设置保存点并在远程数据库上执行操作，然后回滚到保存点。
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.
如果所请求商品在stock表中的可用数量小于订购的数量，那么事务将回滚到neworder保存点。
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.
这也意味着您只能在存储过程的同一次执行中引用保存点，而不能从同一个过程或任何嵌套级别的其他过程的不同执行中引用。
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(显式或隐式)语句，并且取消整个事务。
应用推荐