SQL Server Triggers Interview Question:

Determine how to use the inserted and deleted pseudo tables?

Submitted by: Administrator

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.
Submitted by: Administrator