What are Magic Table?
Answer Posted / puneet sharma
INSERTED and DELETED tables known as MAGIC
TABLES.BECAUSE IN BOTH THE CASES TRIGGER FIRES AND
TEMPORARILLY STORE INSERTED AND DELETED VALUES
RESPECTIVELLY.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is application role in sql server database security? : sql server security
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
what method you can use to reduce the overhead of Reporting Services data sources?
What are dml (data manipulation language) statements in ms sql server?
Explain left outer join and right outer join?
Can we use trigger new in before insert?
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
List out some of the requirements to set up a sql server failover cluster?
What action plan is preferred if sql server is not responding?
What is relationship? What number of sorts of relationship are there?
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
What is transact-sql language?
What is policy based management (pbm)? : sql server database administration
Is it important for a database administrator to understand the operating system and file access?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?