What are Magic Table?
Answer Posted / sharda prasad shukla
MAGIC TABLES NOTHING BUT INSERTED AND DELETED WHICH ARE
TEMPORARY OBJECTS CREATED BY SERVER INTERNALLY TO HOLD
RECENTLY INSERTED VALUES IN THE CASE OF INSERT,TO HOLD
RECENTLY DELETED VALUES IN THE CASE OF DELETE,TO HOLD
BEFORE UPDATING VALUES OR AFTER UPDATING VALUES IN THE CASE
OF UPDATE.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is the difference between a fill factor of 100 and 0?
What does <> symbol mean?
How to receive returning result from a query?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
How does the report manager work in SSRS?
What is row_number function?
How to return the date part only from a sql server datetime datatype?
Can We Use Data-grids For Our Report In Ssrs?
How to use clusters?
What are scheduled tasks in sql server?
What are the two modes of authentication in sql server?
What are sql dirty pages?
What is difference between count (*) and count column?
Can You Use Data Mining Models In Ssrs?
What is plan freezing?