Interested to Buy Any Domain ? << Click Here >> for more details...
What are Magic Table?
- 34 Answers
- 77671 Views
- 3i Infotech, Digiweb, Evalueserve, NIIT, PL, I also Faced
- E-Mail Answers
Answer Posted / krishna pada mandal
Whenever we fire the DML trigger in any table then the two
table is created one in inserted and second is deleted that
is called Magic table. Actually this is temporary table
inserted table contain the copy of all record that are
inserted in the trigger table. And deleted table contain all
records that have been deleted fro, the trigger table.
When we update the table the trigger use both the table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are the Prerequisites for Replication?
Can you explain what are various ways to enhance the ssrs report?
What is transact-sql language?
What new changes are being made in SQL Server?
How to choose all records from the table?
How do you open a cluster administrator?
How to turn off warning messages during php execution?
How to add the custom code in Report?
Why are you getting errors when creating a new odbc dsn?
How do I run sql server 2014?
Can we create clustered index on composite key?
How do you use a subquery to find records that exist in one table and do not exist in another?
Difference between primary key and clustered index?
Explain active/passive and active/active cluster configurations?
Explain the phases a transaction has to undergo?
