What are Magic Table?
Answer Posted / ajay kumar
Whenever a trigger is fired in response to the
INSERT,DELETE,Or UPDATE statement the SQL SERVER creates
two temporary tables, Called Magic Table. The Magic Table
called inserted or deleted. The magic table conceptual
tables are similar in structure to the table on which thw
trigger is difined.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is the guest user account in sql server? What login is it mapped to it? : sql server security
What do you understand by mirroring?
What are the different types of collation sensitivity in sql server?
How to integrate the ssrs reports in application?
How to view existing indexes on an given table using sys.indexes?
Explain about link server in sql server?
What is difference between sql and sql server?
How to implement service broker?
What is a user-defined function in the sql server and what is its advantage?
What is Federation and Federation Member?
What is self contained scalar sub query?
Can two tables have the same primary key?
What is snapshot parameter in ssrs?
What are parameterized reports?
Do comments need to go in a special place in sql server 2005?