What are Magic Table?
Answer Posted / 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 |
Post New Answer View All Answers
What is trace flag in sql server?
what is database replicaion? : Sql server database administration
What are the new features are introduced in sql server 2012 reporting services?
Define cross join in sql server joins?
What is for xml in sql server?
Do you know concepts and capabilities of sql server?
How to get the query of a table in sql server?
Explain optimistic and pessimistic concurrency?
What are diverse clauses that form a part of sql?
Explain unique key in sql server?
How to recreate an existing index in ms sql server?
What is the beast way to write CTE in SQL Server ?
what's new in sql server 2016?
What is the user of Primary key?
Can primary key be a foreign key?