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
What is an XMLReader Class? This is an abstract class available from the System.XML namespace. The XML reader works on a read-only stream browsing from one node to another in a

Audio Expert in C# Required - Generate Audio Engine, Exciting Project! Project Description: We need an EXPERT CODER to help us create an 'audio engine' in C#. We need to b

What are the criteria necessary for an effective and efficient network? a. Performance It can be measured in several ways, including transmit time and response time. b

Generate Function to Create Signed_Body for Instagram Project Description: I want the exact Signed_Body for Instagram The only difference is that I want the most recent ve

cookieless="false" timeout="20" /> Above is sample session state mode specified for SQL SERVER.

Demonstrating use of break, continue & goto - C# Program How can i use break, continue & goto in my assignment, I am looking for a program in C#. It would be feel great if any

What are LeaseTime, Sponsorship Time, Renew on Call Time and Lease Manager Poll Time? In the normal .NET environment objects lifetime is managed by garbage collector. But inrem

Program of addition of byte type variables - C# Program Program of addition of byte type variables, i need program code for performing addition of byte type variables. Can any

I want Workflow Designer (HTML5) Project Description: I am seeking an HTML5 designer for a custom workflow tool. It should have drop and drag functionality. Saving it as XML

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