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
Can you load data into multiple tables at once? : aql loader
Why do we create stored procedures & functions in pl/sql and how are they different?
what is primary key? : Sql dba
What mean sql?
What is dbo in sql?
What is acid property in a database?
what is bcp? When does it used? : Sql dba
What is cost in sql execution plan?
Why select is used in sql?
Can we write dml inside a function in sql server?
How global cursor can be declare with dynamic trigger ?
What are the two parts of design view?
How do you take the union of two tables in sql?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
What is dense_rank in sql?
