Two types of merge tables
".
1.INSERTED
2.DELETED
When we insert the record into the table, the magic table "INSERTED" will be created
In that table the current inserted row will be available. We can access this
record in the "TRIGGER".
When we update a record on the table where trigger is created, the magic tables "INSERTED" and "DELETED" both will be created, the Old data of the updating record will be available in "DELETED" table and, the new data will be availalble in "INSERTED" table, while accessing them inside the trigger.
When we delete the record from the table, the magic table "DELETED" will be created
In that table the current deleted row will be available. We can access this
record in the "INSERTED
Sign up here with your email
ConversionConversion EmoticonEmoticon