Answer Posted / kiran
Trigger is a special type of stored procedure which is
implicitely executed when an insert , update or delete
happens on the data.
We dnt have to call trigger explicitely.
For applying some business rules we can fire trigger at
specific type.
Suppose i want a log when user inserts data on a particular
table i can use trigger.
2 types of trigger
1) DML Trigger - Applies on data -
- Instead of and After Trigger
2)DDL Trigger - Applies on database structure - on table or
database - these triggers came with sql server 2005.
Before sql server 2005 we were having only DML Triggers.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is recursive stored procedure?
how to enter numeric values as hex numbers? : Sql dba
Can we join 3 tables in sql?
Is sql difficult?
what is the use of double ampersand (&&) in sql queries?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
How many clustered indexes can be created on a table?
How will you distinguish a global variable with a local variable in pl/sql?
What is out parameter used for eventhough return statement can also be used in pl/sql?
How do I upgrade sql?
What type of database is cloud sql?
Show code of a cursor for loop.
explain the difference between myisam static and myisam dynamic. : Sql dba
What are the types of keys?
What is query execution plan in sql?
