What are Magic Table?
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
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
How many types of cursor type are there?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
Explain a checkpoint?
How adventureworkslt tables are related?
How to add additional conditions in SQL?
List few advantages of stored procedure.
Write a SQL queries on Self Join and Inner Join.
Mention a few common trace flags used with sql server?
How to find out the list schema name and table name for the database?
How can you fetch alternate records from a table?
What is raid and what are different types of raid levels?
What is the use of keyword with encryption.
How to get the number of affected rows?
Explain the properties of sub-query in sql server?