Interested to Buy Any Domain ? << Click Here >> for more details...
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 the plv (pl/vision) package offers?
How do I save a sql query?
What is sql architecture?
Does sql backup shrink transaction log?
Can we use join in subquery?
What are the uses of merge?
What is the example of procedure?
How many triggers can be applied to a table?
Why we use stored procedure instead of query?
What is a temporal data type?
What programs use sql?
What is difference between sql and mysql?
How many types of relationship are there?
What sql database should I use?
What does pragma mean?
