what is magic table.different types of magic table

Usually Inserted and Deleted Tables are called Magic Tables.Magic Tables does not contain the information about

the Columns of the DataType text,ntext or image.These are maintained by SQL Server for internal processing whenver an update,insert,Delete occur on table.However we can refer these tables in Triggers.

Whenever an updated table statement is fired SQL Server Maintains the original row before updation in a deleted table and New(Updated) row in inserted table.

Have a look at this Magic Table in SQL Server[^].

For more results see this Google search[^].

create trigger c1_InsteadOfInsert on customer1 instead of Insert
as
begin
insert into customer1 select name,city,Country from inserted
end;

insert into customer1(Name,city,Country) values('sohan','Kushinagar','INDIA')

--it will display the inserted records instead of displaying 1 row affected