Answer Posted / rani
Refer this link which nicely demonstrates the Magic Table.
Magic Table are the INSERTED and DELETED tables which we
cannot see from the database, but can be accessed using
Triggers.
When a new row is added an INSERTED table gets created with
the inserted row. Similarly when a row is updated a DELETED
table is created with the deleted row. For update the old
data is moved to the DELETED table and the new updated row
gets created in the INSERTED table.
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
How real and float literal values are rounded?
What is a select query statement in ms sql server?
How to convert binary strings into integers in ms sql server?
Explain about temporary stored procedure?
Mention the different authentication modes in sql server.
What is perspective, have you ever created perspective? : sql server analysis services, ssas
what are triggers? : Sql server database administration
What is precedence constraint?
A trigger can reference objects outside the current database? State true or false.
Explain data warehousing in sql server?
Explain time data type in sal server 2008?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
What is SQL Azure Firewall?
What is transaction server auto commit?
What are the 7 disadvantages to a manual system?