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
MAT LAB programming Project Description: i have simulation and i need to simulate the equation in ,and test the all simulation it working with your work program other code sh

What are the components of WF 4.0? WF having of various components that work together to make desired workflow. The components of WF are given as follows: Workflows and a

Why do we use the XMLHttpRequest object in AJAX? The XMLHttpRequest object is used by JavaScript to transfer XML and other text data among client and server. The XMLHttpRequest

What advantages have Web services over Component Object Model (COM) and Distributed Component Object Model (DCOM)? The benefits of Web services over COM and DCOM are as follow

What is the difference between Stored Procedure (SP) and User Defined Function (UDF)? Some of major differences between a stored procedure and user defined are as follows:-

How many types of diagrams are there in UML? There are nine types of diagrams in the UML as shown below:- 1)Use case diagram: The use case diagram describe "WHAT" of a

Finding the EOQ and TBO - C# Program: Need summer assignment help on c#.

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

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

What are the authentication methods in .NET? 1.Windows authentication 2.Forms authentication 3.Passport authentication 4.None/custom authentication