当sql server级联更新并取消操作时会发生什么?

时间:2021-10-18 07:08:34

When I update a value on a table where the column cascades updates to many other tables (and the other tables have foreign keys that enforce referential integrity on that column) and I cancel the operation? Is the whole operation treated as a transaction and rolled back? I'm cancelling from Sql Management Studio.

当我更新一个表的值时,列级联更新到许多其他表(并且其他表具有在该列上强制引用完整性的外键)并取消操作?整个操作是作为交易处理还是回滚?我正在从Sql Management Studio取消。

1 个解决方案

#1


5  

Yes. That is what A(tomicity) in ACID is all about

是。这就是ACID中A(tomicity)的全部意义所在

#1


5  

Yes. That is what A(tomicity) in ACID is all about

是。这就是ACID中A(tomicity)的全部意义所在