Trigger Interview Questions

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.

1 comment:

Featured Post

Microsoft Azure: Configure Azure App Service Logging

Azure App service logging are the output of runtime trace statement in the different app code. logging feature will help you might only want...

Popular Posts

Welcome to MSDEVBUILD.COM