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
Can we use where clause with group by?
What do you do in data exploration
Do you know what is xpath?
Can we use where and having clause together?
What is sub-query in sql server?
What is sleeping status in sql server?
How to find index size for each index on table?
What is de-normalization in sql database administration? Give examples?
What is always encrypted?
What is default constraint?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
Which trace flags are enabled in sql server?
How to query multiple tables jointly?
What are the differences between stored procedure and the dynamic sql?
Can we use trigger new in before insert?