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

Hi mate,

you may want to search  the web for "when to use triggers in sql server"

I'm sure you'll get lot of information after doing doing a search at google/bing.