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
Can primary key be null?
What is a Join and explain its types?
what is the system function to get the current user's user id? : Sql server database administration
What is a trigger what are the advantages of trigger?
What are Spatial data types in SQL Server 2008
What is the sql case statement used for?
How optimize sql query with multiple joins in sql server?
What do you think of this implementation? Can this be implemented better?
List out the different types of locks available in sql server?
What are different types of table joins?
what is a join and explain different types of joins? : Sql server database administration
How to encrypt Strored Procedure in SQL SERVER?
How to create a stored procedure with a statement block in ms sql server?
What is the importance of concurrency control?
What is attribute hierarchy? : sql server analysis services, ssas