Answer Posted / yoshita
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, to retrieve
all values in the deleted table, use
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
What are the different types of triggers in SQL SERVER?
How to copy data from one table to another table?
How to add an address record into adventureworkslt?
If a stored procedure is taking a table data type, how it looks?
What can be used instead of trigger?
In what three ways is the return statement used in a stored procedure?
How do I delete a sql server database?
Name 3 ways to get an accurate count of the number of records in a table?
How to use user defined functions in expressions?
How to select some specific rows from a table in ms sql server?
What are the general features of sql server management studio? : sql server management studio
What is the use of RDBMS?
What is attribute? : sql server analysis services, ssas
How to encrypt data between dialogs?
What is sql server profiler?