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
How many types of local tables are there in sql server?
Is sql server implemented as a service or an application? : Sql server database administration
Define master database?
How to defragment table indexes?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
Find nth lowest salary or get nth lowest salary?
What is data modeling and Reterminal integrity?
What do you mean by 'normalization'?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
What is thr feature of change data capture?
What do you mean by sql server agent?
Define left outer join in sql server joins?
What are functions in the sql server?
What is SubQuery in SQL Server 2008
What stored by the master? : sql server database administration