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 a not null constraint?
What is difference between unique and primary key?
What are the disadvantages of merge replication?
What is indexing a document?
How to convert character strings into numeric values?
What have included columns when we talk about sql server indexing?
Detail about query optimizer?
Do you know what are different types of replication in sql server?
How much is a sql server license?
What is the New in SQL server 2008?
What is attribute relationships, why we need it? : sql server analysis services, ssas
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
what is a traditional network library for sql servers? : Sql server database administration
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What is the difference between stored procedure and functions?
