There are two magic tables named inserted and deleted.
On Insertion :
whenever an insert takes place, the data goes into inserted
table before the commit of the transaction.
On Deletion :
Whenever a row gets deleted from a table, data goes into
deleted table.
On Update :
Since an update statement is a combination of delete and
insert so in case of update data goes in both, inserted and
deleted tables.
No comments:
Post a Comment