In most trigger situations, you need to know what changes were made as part of the data modification. You can find this information in the
deleted tables. For the
AFTER trigger, these temporary memory-resident tables contain the rows modified by the statement. With the
INSTEAD OF trigger, the
deleted tables are actually temporary tables created on-the-fly.
deleted tables have identical column structures and names as the tables that were modified. Consider running the following statement against the
UPDATE [Production].[Product] SET [ListPrice] = '10' WHERE ProductSubcategoryID = 23
When this statement is executed, ...