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 is the use of partition by in sql?

706

---

What are reports usually used for?

755

---

how to include character strings in sql statements? : Sql dba

730

---

What is attribute indicator in pl sql?

712

---

How do I find duplicates in a single column in sql?

728

---

---

what does myisamchk do? : Sql dba

738

---

What is partition in sql query?

711

---

Is primary key always clustered index?

732

---

What is triggering circuit?

765

---

Does sql require a server?

702

---

What is difference between rank () row_number () and dense_rank () in sql?

796

---

What is left join in sql?

748

---

write an sql query to find names of employee start with 'a'? : Sql dba

773

---

what is the use of friend function? : Sql dba

725

---

how to rename an existing table in mysql? : Sql dba

721

---