Answer / arvind kumar

Magic tables are Inserted And Deleted which fires when we
use triggers and they are also work like temporary tables to
hold the data.

Answer / kanna

Magic Table

When we use Trigger Statement in SQL that time atomatic created in Magic Tables INSERTED and DELETED tables and UPDATE also

Answer / sushanta kumar sahoo

magic tables are nothing but inserted and deleted in which
the temporary object created by the server internally to
hold the recently inserted values.

Answer / rohit kumar singh

update & delete are two magic tables.
(a)update
insert and update
(b)delete

Answer / golu singh

In SQL server magic table is nothing more than an internal
table which is created by the SQL server to recover recently
inserted, deleted and updated data into SQL server database.
That is when we insert or delete any record from any table
in SQL server then recently inserted or deleted data from
table also inserted into inserted magic table or deleted
magic table with help of which we can recover data which is
recently used to modify data into table either use in
delete, insert or update to table. Basically there are two
types of magic table in SQL server namely: inserted and
deleted, update can be performed with help of these twos.
Generally we cannot see these two table, we can only see it
with the help Trigger’s in SQL server.

For more details please check out the following link...
http://mindstick.com/Blog/211/Magic%20Table%20in%20SQL%20Server

It might resolve your problem.
Thanks!!

Answer / shweta sharma

inserted and updated are the rite answer

Answer / krishna pada mandal

Whenever we fire the DML trigger in any table then the two
table is created one in inserted and second is deleted that
is called Magic table. Actually this is temporary table
inserted table contain the copy of all record that are
inserted in the trigger table. And deleted table contain all
records that have been deleted fro, the trigger table.
When we update the table the trigger use both the table.

Answer / neeraj sharma

When we fire the trigger then the data goes to temporary
tables. when we execute insert, delete, update trigger the
the data goes to temporary tables. these temporary tables
are called as magic tables. There to types of magic tables:
1. Inserted
2. Updated

Answer / sandeep

magic table two part
1)Inserted
a)Insert
b)update
2)Deleted

Answer / pappu

magic tables are created by great magician Mr.Muthukad....
for further details u have to contact him...

Explain filestream storage of sql server 2008?

0 Answers  

how to select a field with firstletter as capital and remaining are small letters

11 Answers  

How to create a ddl trigger using "create trigger" statements?

0 Answers  

Explain full-text query in sql server?

0 Answers  

What is use of except clause? How it differs from not in clause?

0 Answers  

What is query optimizer in sql server?

0 Answers  

wat is tuff file in log shipping, wt is d use of tht file?

1 Answers   TCS,

What are subquery and its properties?

0 Answers  

What is bit data type?

0 Answers  

what is bit data type? and what are the information that can be stored inside a bit column?

2 Answers  

How many cores do I need for sql server 2016?

0 Answers  

table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output

7 Answers