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.

Is it possible in sql table to have more than one foreign key?

0 Answers  

What do you understand by a view? What does the with check option clause for a view do?

0 Answers  

How to include text values in sql statements?

0 Answers  

How to view existing indexes on an given table using sp_help?

0 Answers  

What is the contrast amongst drop and truncate?

0 Answers  

Do comments need to go in a special place in sql server 2005?

0 Answers  

What is database black box testing?

0 Answers  

Can you explain what is indexed view? How to create it?

0 Answers  

What are the system database in sql server 2008?

0 Answers  

What is the log shipping?

0 Answers  

How can sql injection be stopped? : sql server security

0 Answers  

Difference between Function and Procedure-in general?

6 Answers