Doubt about triggers in T-SQL

1

As far as I understand, when a trigger is executed for the insert event, the new records are added to a virtual table called inserted.

When running for a delete event, the deleted records are added to a temporary table named deleted.

But when it is executed for an update event, the records that we are going to update before said update are added to the deleted table, and the same records already updated are added to the inserted table.

My question is: why, for the update event, are they not added to a temporary table called update or something like that? Why do these two tables have to be added before and after the update?

    
asked by Sergio AG 18.06.2018 в 03:19
source

0 answers