Answer / anilkumar,bijapur

The magic table is when we "INSERT" a table values that
values stored into table it's one magic
and another magic is "DELETE" when we DELETE the values in
a table the compiler delete the values whatever you are
stored

@)INSERT

@)DELETE

Answer / manish kumar

Magic tables are created when data is inserted or updated
in the normal tables. They get deleted when the commit is
done. They are used for the auditing purposes.
They are useful in keeping track of the insertion and
updation on the database.

Answer / puneet sharma

INSERTED and DELETED tables known as MAGIC
TABLES.BECAUSE IN BOTH THE CASES TRIGGER FIRES AND
TEMPORARILLY STORE INSERTED AND DELETED VALUES
RESPECTIVELLY.

Answer / ajay kumar

Whenever a trigger is fired in response to the
INSERT,DELETE,Or UPDATE statement the SQL SERVER creates
two temporary tables, Called Magic Table. The Magic Table
called inserted or deleted. The magic table conceptual
tables are similar in structure to the table on which thw
trigger is difined.

Answer / danish aleem

An implicit trigger is fired when ever we insert, update or delete, then the two temporary tables are created i.e.insert and delete. So these temporary tables are termed as MAGIC TABLES.

* These are named as MAGIC because they are removed automatically when the specified query is committed.

Answer / sharda prasad shukla

MAGIC TABLES NOTHING BUT INSERTED AND DELETED WHICH ARE
TEMPORARY OBJECTS CREATED BY SERVER INTERNALLY TO HOLD
RECENTLY INSERTED VALUES IN THE CASE OF INSERT,TO HOLD
RECENTLY DELETED VALUES IN THE CASE OF DELETE,TO HOLD
BEFORE UPDATING VALUES OR AFTER UPDATING VALUES IN THE CASE
OF UPDATE.

Answer / johnny

Magic? I'm still waiting for the rabbit to appear...

Answer / digvijay kumar singh

Magic table is Temporary type table. it is created when
trigger perform the insert,delete and update action. trigger
have two type magic table:-
1:- inserted table.
2:- deleted table.

when trigger perform the insert and update action on table
then trigger used the Inserted magic table and deleted magic
table used at deletion time.




i hope you will understand..................

Answer / sabahuddin

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.

Answer / sabahuddin

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.

How much space does sql server 2016 take?

0 Answers  

What is pivot and unpivot?

0 Answers  

What does set rowcount do?

0 Answers  

While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

0 Answers  

how can i store resumes in database?

3 Answers   HCL,

how to delete duplicate rows from table

9 Answers   CSC,

Mention the differences between local and global temporary tables.

0 Answers  

What is the difference between update lock and exclusive lock?

0 Answers  

What is difference between unique and primary key?

0 Answers  

Explain the flow of creating a cube? : sql server analysis services, ssas

0 Answers  

Benefits of Stored Procedures?

0 Answers   Wipro,

What is in place upgrade in sql server?

0 Answers