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 xdr?
What are the types of indexing?
Explain query editor regions
What are the different types of sql server replication? : sql server replication
How to view existing indexes on an given table using sp_help?
What is pivot and unpivot?
Explain transaction isolation levels in sql server?
What is tablesample?
What is tempdb database? : SQL Server Architecture
What do you mean by tablesample?
What is change data capture (cdc) feature?
What are sp_configure commands and set commands?
Define msdb database?
What are the export options of ssrs?
What is precedence constraint?