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 unique and xaml nonclustered index
How to count rows with the count(*) function in ms sql server?
What is in place upgrade in sql server?
List the ways in which dynamic sql can be executed?
What is the return type of executeupdate ()?
What are the differences between user defined functions and stored procedures?
Why do we partition data?
Explain filtered indexes benefits?
Explain important index characteristics?
What are different types of raid levels?
What is the Difference Between Primary and Foreign Key?
What are the two modes of authentication in sql server?
What is isolation levels?
Which tcp/ip port does the sql server run on? How can it be changed?
How can you know if the row fetched from cursor is still valid in underlying table?