Triggers are objects that run when data changes (or in some cases, schema changes). They can run against tables or views and can be, well, triggered by inserts, updates, or deletes. There are some caveats on using them against a view (besides my personal opinion, which is: please don’t).
Each trigger has two tables that you can use to query data that has changed. There is an INSERTED table and a DELETED table. If you are firing a trigger on an INSERT, there will be records in the INSERTED table but none in the DELETED table. If you are firing a trigger on a DELETE, there will be records in ...
