且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

Sql Server 中的嵌套事务

更新时间:2023-02-03 12:51:11

对于嵌套事务,提交不会将任何更改写入磁盘,除了***事务.然而,无论事务的级别如何,回滚都有效,所以是的,它将回滚内部事务.

With a nested transaction, a commit does not write any changes to disk, except for the top level transaction. A rollback, however works regardless of the level of the transaction, so yes, it will roll the inner transaction back.