When and why do we use triggers

Triggers are mainly used for automation. On a table you can create insert, update and delete triggers.

Insert trigger will execute a query when a row is inserted in table

Update trigger will execute a query when a row is updated in table

Delete trigger will execute a query when a row is deleted in table

http://searchsqlserver.techtarget.com/feature/Why-use-triggers-in-Microsoft-SQL-Server