1.

Explain Trigger And Trigger Types?

Answer»

A trigger is a special kind of a store procedure that executes in response to certain ACTION performed on the table like insertion, deletion or UPDATING of data

Basically there are two LOGICAL types:

  • DDL triggers
  • DML triggers

DDL triggers you can categorize:

  • Transact-SQL DDL Trigger
  • CLR DDL Trigger

DML trigger types are:

  • INSTEAD OF DML trigger
  • AFTER DML trigger

There is one special type trigger called logon trigger in sql server.

A trigger is a special kind of a store procedure that executes in response to certain action performed on the table like insertion, deletion or updating of data

Basically there are two logical types:

DDL triggers you can categorize:

DML trigger types are:

There is one special type trigger called logon trigger in sql server.


Discussion

No Comment Found

Related InterviewSolutions