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
@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.