What is trigger?

                                              Trigger is block of sql statement.  In simple word it is event which is raised when there is any DML or DDL operation performed.

Question related Trigger :

1.Can I call trigger ?

Ans - No,You can not call trigger explicitely.It will be called implecitely.

2.How many type of triggr are in sql server?

Ans - Mainly two type of trigger are in sql server.

1.DDL trigger : which will be raised when DDL command will be performaned like DROP ,CREAT,Truncate at database level

2.DML trigger : which will be raised when DML command will be performed like insert,update and delete

   Also DML tigger is divided into two type

1) INSTEAD OF TRIRRGER
2) AFTER TRIGGER