Interested to Buy Any Domain ? << Click Here >> for more details...
What are Magic Table?
- 34 Answers
- 77710 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 are acid properties of transaction?
What is store procedure? When do you use?
What are the approximate numeric data types?
Explain about integration services of Microsoft SQL server?
Characterize join and name diverse sorts of joins?
Define Wed Edition in SQL Azure?
Explain the difference between HTTP and HTTPS in database?
Explain Geometry datatype in sql server 2008 with example
Which are the important points to note when multilanguage data is stored in a table?
How to create and drop temp table in sql server?
How does clustered and non clustered index work?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
What are the 7 disadvantages to a manual system?
What is attribute hierarchy? : sql server analysis services, ssas
