Interested to Buy Any Domain ? << Click Here >> for more details...
What are Magic Table?
- 34 Answers
- 77664 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 are the types of indexing?
What is service broker?
Can you tell me some of the common replication dmv's and their use? : sql server replication
How much space does sql server 2016 take?
can an automatic recovery be initiated by a user? : Sql server administration
Difference between aggregate functions of sql?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
What is scan table/view and seek table/view when its occurs? : sql server database administration
Describe in brief databases and sql server databases architecture.
Why I am getting this error when renaming a database in ms sql server?
How to filter records of table in SQL SERVER?
How to create a large table with random data for index testing in ms sql server?
Can foreign key be deleted?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
How to move database physical files in ms sql server?
