Different types of triggers in sql, DOT NET Programming

Assignment Help:

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.


Related Discussions:- Different types of triggers in sql

I need export data using json, I need Export Data using JSON Project Des...

I need Export Data using JSON Project Description: We could like to share our data with other websites via JSON. We are presently using Entity Framework with MySQL. We req

I want simple academic project, Project Description: I want very simple ...

Project Description: I want very simple app in C# in visual studio Windows forms app Very simple database management app - three buttons - search , delete, add records and

What are the different implementations of linq, What are the different impl...

What are the different implementations of LINQ? The different implementations of LINQ are: LINQ to SQL - Refers to a component of.NET Framework version 3.5 that provides a

Difference b/w system.string and system.stringbuilder class, What are the d...

What are the difference b/w System.String and System.StringBuilder classes? The System.StringBuilder can have mutable string where a variety of operations can be performed whil

Develop shop and veterinarian online, Among the items that are related to t...

Among the items that are related to the implementation of an application for automation of processes, are shown as follows: a) The online patient registry through which patients

Digital invy - inventory management, Project Description: Digital invy -...

Project Description: Digital invy - inventory management Main Features User friendly windows based software Multi Branch Multi company facility Multi user Integra

Image viewing in datagrid view, im retrieving the path of image from the da...

im retrieving the path of image from the database i want to get the image in that path to be displayed in my datagridviewvolumn

Hash table, What is a Hash Table? You can access an array using the IND...

What is a Hash Table? You can access an array using the INDEX value of that array, but how many times you know the real value of the index. The Hashtable provides a way of acce

We need programmers and accountants, We need programmers and accountants ...

We need programmers and accountants Skills required are .NET, C# Programming, Graphic Design, Commercials, Software Architecture

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd