Interested to Buy Any Domain ? << Click Here >> for more details...
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
what is database replication? : Sql server database administration
What is a file group?
Do you know what is openxml in sql server?
What are the different types of backups that exist?
Can we install sql server 2016 on windows 7?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What is the difference between Stored Procedures and triggers?
Does an index slow down updates on indexed columns?
What is meant by referential integrity?
What is an active database?
Is natural join and equi join same?
What is scan table/view and seek table/view when its occurs? : sql server database administration
What is inner join in sql server joins?
What are subqueries in sql server?
