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
How to implement service broker?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
Explain intellisense for query editing
How many servers can we create in a single subscription?
What is the difference between varchar and varchar types?
What is a document index?
How to insert a new row into a table with "insert into" statements in ms sql server?
What is Federation Root Database?
In what three ways is the return statement used in a stored procedure?
How to use order by with union operators in ms sql server?
How to disable stored procedure sql server?
Can a database be shrunk to 0 bytes, if not, why?
Write the syntax for stuff function in an sql server?
What is policy management?
Explain primary key?