which will default fire first 
statement level trigger or row level trigger

Answer Posted / ram

Before Insert/update/delete triggers executes first..
In this statement level triggers execute first..the order flows as below
Statement level -- before trigger
row level -- before trigger
row level -- after Insert/update/delete triggers
statement level -- after Insert/update/delete triggers

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3699


What is sql partition?

753


Can a composite key be null?

713


What is before and after trigger?

691


Can %notfound return null after a fetch?

756






Which data type is a composite type?

736


How long it takes to learn pl sql?

724


What trigger means?

730


List different type of expressions with the example.

698


How do you modify a table in sql?

802


How do you use join?

703


what is heap table? : Sql dba

803


What is integrity in sql?

750


What are the two types of cursors in pl sql?

735


what is the command used to fetch first 5 characters of the string? : Sql dba

1368