Interested to Buy Any Domain ? << Click Here >> for more details...
What are Magic Table?
- 34 Answers
- 79584 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 an index in sql?
How to execute a sql statement using mssql_query()?
How do I run a trace in sql server?
What are ddl triggers and types of ddl trigger?
What are pessimistic lock and optimistic lock?
Explain forward - only cursors?
What is sql server profiler?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
Why do we use non clustered index?
Can We Use Data-grids For Our Report In Ssrs?
How to drop existing indexes in ms sql server?
How to change the ownership of a schema in ms sql server?
What is executereader?
Why do we backup Active Directory ?
Who developed sql server?
