SQL Server Triggers Question:
Determine how to use the inserted and deleted pseudo tables?
Answer:
Inserted and deleted pseudo tables contain the New and Old values of the data that initiating the Trigger. These tables can be used for database maintenance and dynamic modification to data. These tables can be examined by the trigger itself. The tables themselves cannot be altered.
Previous Question | Next Question |
Explain Syntax for viewing, dropping and disabling triggers? | How to apply cascading referential integrity in place of triggers? |