What are Magic Table?
- 34 Answers
- 80324 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
How to connect php with different port numbers?
Why we use the openxml clause?
What is acid mean in sql server?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
How to provide default values to function parameters?
Equi join and non equi join is possible with sql server?
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?
What is self contained sub query?
How can I check that whether automatic statistic update is enabled or not?
How do I find the sql server version?
Why and when do stored procedure recompile?
Can you index views?
What are different types of constraints?
Does view occupy space?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
