What are Magic Table?
- 34 Answers
- 80285 Views
- 3i Infotech, Digiweb, Evalueserve, NIIT, PL, I also Faced
- E-Mail Answers
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 self contained sub query?
Does view occupy space?
What are wait types?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
How do I start sql server 2017?
Explain system functions or built-in functions? What are different types of system functions?
What is sql or structured query language?
What is a view in sql?
How can we solve concurrency problems?
What are the different types of subquery?
Disadvantages of the indexes?
What are the different subsets of sql?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What is the difference between for xml raw and for xml auto?
What is subquery? Explain the properties of a subquery?
