Interested to Buy Any Domain ? << Click Here >> for more details...
What are Magic Table?
- 34 Answers
- 79665 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
How is foreign key related to primary key?
How to transfer data from a cursor to variables with a "fetch" statement?
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
If a table does not have a unique index, can a cursor be opened on it?
How to create a view using data from another view?
If user is owning any SQL Objects, can we drop that user
What is local temp table?
Why use “pivot” in sql server?
What is the difference between varchar and nvarchar datatypes?
What is view in sql?
What is sub-query in sql server?
Give main differences between "Truncate" and "Delete".
What are the new scripting capabilities of ssms? : sql server management studio
What is the use of builtinadministrators group in sql server? : sql server security
What is the difference between SQL notification and SQL invalidation?
