Magic table hold the recently inserted values in the case of insert and to hold recently deleted values in the case of delete

Use: Often used in Trigger

e.

INSERT INTO emp

SELECT i.id, i.names

FROM INSERTED i   // Magic Table