sql server interview questions | triggers

Explain Triggers? Trigger is one of the database objects and executes set of Transact SQL Statements Automatically in response to an event (INSERT, UPDATE,DELETE etc) with in database. Generally Triggers are used to implement business rules. How many types of triggers are there in Sql Server 2005? There are two types of triggers • Data Manipulation language (DML) triggers • Data Definition language (DDL) triggers DML triggers (implementation) will run when INSERT, UPDATE, or DELETE statements modify data in a specified table or view. DDL triggers will run in response to DDL events that occur on the server such as creating, altering, or dropping an object, are used for database administration tasks What are the different modes of firing triggers? After Trigger: An AFTER trigger fires after SQL Server completes all actions successfully Instead of Triggers: An INSTEAD OF trigger causes SQL Server to execute the code in the trigger instead of the operation that caused the trigger to fire. If you would like to view all SQL Server related topics click below link SQL Server related topics