Different types of triggers in sql, DOT NET Programming

What are the different types of triggers in SQl

There are 2 types of triggers in the SQL server 2000 :-

1) INSTEAD OF triggers:

The INSTEAD OF triggers fire in place of the triggering action. For e.g., if an INSTEADOF UPDATE trigger exists on the Sales table and an UPDATE statement is executed against the Salestable, the UPDATE statement will not modify any row in the sales table. In spite, the UPDATE statement causes the INSTEAD OF UPDATE trigger to be executed, which might or might not modify the data in the Sales table.

2) AFTER triggers

The AFTER triggers execute the following in the SQL action, like insert, delete,or update. This is the traditional trigger that existed in the SQL SERVER. INSTEAD OF triggers gets executed automatically before the Primary Key & the Foreign Key constraints are checked, whereas the traditional AFTER triggers gets executed after these constraints are checked.

Unlike INSTEAD OF triggers, AFTER triggers can be created on views.

Posted Date: 9/24/2012 3:24:28 AM | Location : United States







Related Discussions:- Different types of triggers in sql, Assignment Help, Ask Question on Different types of triggers in sql, Get Answer, Expert's Help, Different types of triggers in sql Discussions

Write discussion on Different types of triggers in sql
Your posts are moderated
Related Questions
Howto create a simple stylesheet for a web application

Explain the DataAdapter.Update() and DataSetAcceptChanges() methods. The DataAdapter.Update() method calls any of the DML statements, like UPDATE, INSERT, or DELETE statements,

Site minder Authentication in SharePoint We have fit site minder agent in SharePoint 2010. We would like to have incorporate with site minder agent. Currently site-minder age

I need Custom Login Page for Sharepoint 2013 with Active Directory Project Description: I would like to prepare a webpart or an application for Sharepoint 2013 foundation.

Project Description: I need to get lync server 2013 fixed the issues it has hit: 1) Can't connect to it outside network, I think small firewall problem with a little issue in

Reversing the Numbers - C# Program Hello guys i need your advice. How can i reverse the integer number in c# project? Please recommend some examples.

What is Windows Workflow Foundation (WF)? Windows Workflow Foundation (WF) is a technology that was first introduced in .NET Framework 3.0. WF having of a programming model, a

A fresh web project utilizing ASP.NET 4.5, MVC 5 with Visual Studio 2013 a) Excellent web layout DESIGN skills using CSS. b) Solid experience with ASP.NET 4.0 MVC 4. c) Cu

Professional TELERIK Bind MS ACCESS Required: 1. Including custom fields to the Schedule. 2. Schedule Calendar Sync with Outlook 3. Selecting display in Schedule res

Web Application and Web Service For this part of the assignment, you are to develop a web application and web service using technologies and techniques taught in this subject