Virtual Tables a Trigger uses | SansSQL

Thursday, June 12, 2008

Virtual Tables a Trigger uses

Inserted and Deleted are the two tables that are virtual and is used by a trigger in order to store the data that is inserted and deleted using a trigger.


Unknown said...

DML triggers use the deleted and inserted logical
(conceptual) tables. They are structurally similar to the
table on which the trigger is defined, that is, the table
on which the user action is tried. The deleted and inserted
tables hold the old values or new values of the rows that
may be changed by the user action. For example,

lizza kim said...

If somebody wants expert take on the main topic of blogging next I advise him/her to go to this site, continue the fussy job.crp furniture

Post a Comment