创建触发器后，将自动创建两个表，这些表是什么？ [英] After Creating Triggers two tables will created automatically,What are those tables?

问题描述

创建触发器后，将自动创建两个表，这些表是什么？

After Creating Triggers two tables will created automatically,What are those tables?

推荐答案

你的意思是在两个表下面吗？

1 。插入

2.删除

Do you mean below two tables?
1.Inserted
2.Deleted

如果你已经为任何表实现了任何触发器，那么<​​br />
无论何时将记录插入到表，该记录将在INSERTED Magic表中。

每当您更新该表中的记录时，该现有记录将位于DELETED Magic表中，并且修改后的新数据将位于INSERTED Magic中table。

每当您删除该表中的记录时，该记录将仅在DELETED Magic表中。

这些魔术表用于触发器内部，用于跟踪数据事务。

If you have implemented any trigger for any Tables then,
Whenever you insert a record into a table, that record will be in the INSERTED Magic table.
Whenever you update the record in that table, that existing record will be in the DELETED Magic table and the modified new data with be in the INSERTED Magic table.
Whenever you delete a record in that table, that record will be in the DELETED Magic table only.
These magic tables are used inside the Triggers for tracking the data transaction.

这篇关于创建触发器后，将自动创建两个表，这些表是什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！