FreeJobAlert.Com

Government Jobs | Results | Admit Cards

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

Tags: sql server triggers, sql server triggers 2005, sql server triggers after insert, sql server triggers before insert, sql server triggers interview questions, sql server triggers on update

Responses to “sql server interview questions | triggers”

  1. @arun

    1.To get latest recruitment updates visit regularly https://www.freejobalert.com
    (or)
    2.To get daily free SMS alerts for all Government/Sarkari Naukri jobs, Bank jobs, Engineering jobs, Police and Defence jobs, Teaching jobs and other Govt jobs on your mobile send SMS as “ON GOVTJOBSALERT” to 9870807070. Make sure you give SPACE after ON.
    (or)
    3.To get daily E-mail alerts on Jobs enter your E-mail ID at right side top corner of the page and click on SUBSCRIBE button.

Leave a Comment