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取消。