What are Magic Table?
Answers were Sorted based on User's Feedback
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.
Is This Answer Correct ? | 0 Yes | 0 No |
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
Is This Answer Correct ? | 0 Yes | 0 No |
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.
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / rohit kumar singh
update & delete are two magic tables.
(a)update
insert and update
(b)delete
Is This Answer Correct ? | 0 Yes | 0 No |
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!!
Is This Answer Correct ? | 0 Yes | 0 No |
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.
Is This Answer Correct ? | 0 Yes | 0 No |
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
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / sandeep
magic table two part
1)Inserted
a)Insert
b)update
2)Deleted
Is This Answer Correct ? | 24 Yes | 26 No |
Answer / pappu
magic tables are created by great magician Mr.Muthukad....
for further details u have to contact him...
Is This Answer Correct ? | 0 Yes | 3 No |
Where are full-text indexes stored?
Can I recover a damaged SQL Server 2008 database with the undamaged .mdb and .ldf files?
What is a Join in SQL Server?
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
how to get rank of diffrent student in same table based on newly inserted row in sql server2008
What are the different types of sql server replication? : sql server replication
What is log in sql server?
Which are the new data types introduced in sql server 2008?
Which are new data types introduced in sql server 2008?
how to get max salary with employee number by using one select query and max function ??
What is a db view?
What is the size of transaction log file?