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
I need asp.net print page task Project Description: I have a little task on asp.net, I need to print a text data to receipt printer from web page, I used the subsequent code

I need C# API for bitfinex Project Description: Hi, I need a developer to build a library in C# that connects to the bitfinex API. The library must implement all the authenti

I have the project that takes screen shots and saves in the specific folder.(eg.Screen0001) but the problem is that if i close application and run it again then it replace the exis

Duplicate a Website I need a customer management site Please help me out and what I need to get. I need all charteristics of above mentioned site a) Effects b) Mobil

What is the significance of Finalize method in .NET? The .NET Garbage collector does atmost all clean up activity for your objects. But unmanaged resources (like - Windows API

When we create a private constructor, we can not create object of the class directly from the client. So you will use the private constructors whenever you do not want instances of

I want to prepare one web based application which have student registration and according to semester and every time it will change as per semester change according, now student ge

I need to develop a new website. Previous site was not good and I need better one with not only static but using also more details . Skills required: .NET, MySQL, C# Programm

This assignment aims to give you a deeper understanding of a 3-tiers integrated application, which groups together several topics taught in this course. This assignment asks yo

Find out the Factorial - C# Program I've been trying so many codes for this but those codes didn't work well. Please write the code for find out the factorial of an integer nu