What are Magic Table?
Answer Posted / durga prasad.g
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 ? | 67 Yes | 7 No |
Post New Answer View All Answers
What are scalar functions in sql?
Explain “row_number()” in sql server with an example?
Explain can you implement data mining in ssrs?
What is indexing and its types?
How to override dml statements with triggers?
What are the different types of collation sensitivity?
How do I find the size of a sql server database?
What is join query?
What is xml datatype?
How to create an identity column?
what are user defined datatypes and when you should go for them? : Sql server database administration
Explain in brief about Microsoft SQL server?
What is a domain constraint give an example?
Do comments need to go in a special place in sql server 2005?
What is indexing a document?