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
Can we use pragma autonomous_transaction in trigger?
What are audit control procedures?
What are the different types of normalization?
Describe in brief databases and sql server databases architecture.
How to find the service pack installed? : sql server database administration
How to handle error or exception in sql?
What is nested transaction?
What are data files?
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
Explain the stored procedure?
How much memory that we are using in Logshipping Concept?
Can we insert data if clustered index is disabled?
what protocol both networks use? : Sql server database administration
What are the security related catalog views? : sql server security
What is a cache in ssrs?