Interested to Buy Any Domain ? << Click Here >> for more details...
What are Magic Table?
- 34 Answers
- 78670 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
How many non clustered indexes there can be on table ?
What is a transactions?
Explain different backup plans?
Define tempdb database?
How to define output parameters in stored procedures?
List some of the rules that apply to creating and using a ‘view’
How do I view views in sql server?
please differentiate between delete and truncate?
How can we get count of the number of records in a table?
What is the syntax for encrypting a column in SQL Server?
How to create a user name in a database?
Do you know what are the restrictions that views have to follow?
Explain about local stored procedure?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
Explain the working of sql privileges?
