Answer Posted / mohit tyagi(siyana bulandshaha

Basically there are three types of triggers, but the way to
use is differ. it doesn't matter on which we are
implementing these trigger.
triggers are:-
1. Cyclic Cascading Triggers.
2. Mutating Triggers.
3. Insted Off Triggers.

we can implement all these trigger on both module i.e
1.Application
2.Database

these both module are associate with the type of
implementation i.e.
1. Insert/delete/update
2. Before/After
3. Statement level/Row level

except this theory there are various ways to represent the
sql trigger. but all have the same concept for
implementation. so never confuse in order to represent the
sql trigger.

What does select count (*) mean in sql?

552

---

discuss about myisam key cache. : Sql dba

563

---

What is java sql driver?

550

---

what are date and time data types in mysql? : Sql dba

504

---

Explain architecture of sql server notification services?

622

---

---

How do you bind variables in pl sql?

580

---

What are the uses of merge?

720

---

What normalization means?

527

---

What does select * from mean in sql?

1994

---

how to enter numeric values as hex numbers? : Sql dba

570

---

What kind of join is join?

559

---

What is dml with example?

519

---

What are the possible values that can be stored in a boolean data field?

517

---

what is the difference between truncate and drop statements? : Sql dba

554

---

what is the difference between nested subquery and correlated subquery?

549

---