What are Magic Table?
- 34 Answers
- 73435 Views
- 3i Infotech, Digiweb, Evalueserve, NIIT, PL, I also Faced
- E-Mail Answers
Answer Posted / shailendra kashyap
Magic Tables:
Whenever a trigger fires in response to the
INSERT,DELETE,or UPDATE statement,two special tables are
created.These are the insert and the delete tables.They are
also referred to as the magic tables.These are the
conceptual tables and are similar in structure to the table
on which trigger is defined(the trigger table).
The inserted table contains a copy of all records that are
inserted in the trigger table.
The deleted table contains all records that have been
deleted from deleted from the trigger table.Whenever any
updation takes place,the trigger uses both the inserted and
deleted tables
| Is This Answer Correct ? | 18 Yes | 3 No |
Post New Answer View All Answers
What is check constraint in sql server?
What the different components of Replication and what is their use?
Explain system scalar functions?
How will you monitor replication latency in transactional replication? : sql server replication
What are Spatial data types in SQL Server 2008
Is sql server 2016 free?
What are the advantages of paper records?
How to add the custom code in Report?
When would you prefer to have a minimum number of indexes?
What are the types of dml?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
What are the different types of upgrades that can be performed in sql server?
What are the steps to insert a table?
Where is trigger in sql server?
What is the ‘fillfactor’?
