Interested to Buy Any Domain ? << Click Here >> for more details...
What are Magic Table?
- 34 Answers
- 79582 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 is use of except clause?
how can you attach more than 20 ldf files in sql server
What is always encrypted?
Please explain what is “asynchronous” communication in sql server service broker?
How to generate create view script on an existing view?
How can we migrate from SQL server to SQL Azure?
Explain what are the basic functions for master, msdb, model, tempdb databases?
What are number line correlation administrators will use while working with a subquery?
What are the 7 disadvantages to a manual system?
Explain the ways to controlling cursor behavior?
Why should we go for stored procedures? Why not direct queries?
Give me any three differences between Truncate and Delete.
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
What is similarity and difference between truncate and delete in sql?
How to use copy and concatenate commands in SQL?
