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 are number line correlation administrators will use while working with a subquery?
your distribution database is full what will u do
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
Where actually sql azure database is hosted?
What is save transaction and save point?
Explain why variables called the most powerful component of ssis?
Explain what are commit and rollback in sql?
What is the New in SQL server 2008?
What is sleeping status in sql server?
Describe the left outer join & right outer join. : sql server database administration
What is the purpose of sql profiler in sql server? : sql server database administration
Explain what is the difference between union and union all?
Which trace flags are enabled in sql server?
Why are sql functions used?
How to enable tcp/ip protocol on a sql server?
