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 self contained sub query?
What is delete query?
What is field with example?
Mention the differences between having and where clause.
how to create “alternate row colour”?
How can you stop stored procedures from recompiling?
Which tcl commands are available on the sql server?
What is filter index?
What is difference between aggregate and analytic function?
What is msdb database? : SQL Server Architecture
What is the size of transaction log file?
How do you run a trace?
How can I get data from a database on another server?
what is package and it uses and how can u call a package
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
