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 would you store your query in an SSRS report or a Database server?
What is co-related sub query?
Explain what is meant by replication of database?
How to use subqueries in the from clause in ms sql server?
What is command parameter in ssrs?
How do you run a trace?
What do you mean by an execution plan? Why is it used?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
how to avoid cursors? : Sql server database administration
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
Where the sql logs gets stored? : sql server database administration
What are the elements of dbms?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
What do you understand by a view?
What is the beast way to write CTE in SQL Server ?