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 different types of schemas?
Does the unique constraint create an index?
How do triggers work?
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?
How to assign new column names in a view?
How can we delete Duplicate row in table?
How to name query output columns in ms sql server?
What is extended stored procedures?
what do you understand by change data capture?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
Is oracle faster than sql server?
What is the difference between push and pull subscription? : sql server replication
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
What is difference between count (*) and count column?
How to transfer an existing table from one schema to another schema in ms sql server?