SQL Server Triggers Question:
Download Questions PDF

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.

Download MS SQL Server Triggers Interview Questions And Answers PDF

Previous QuestionNext Question
Explain Syntax for viewing, dropping and disabling triggers?How to apply cascading referential integrity in place of triggers?