Answer Posted / sarat

There are 4 types of Triggers

# Row Triggers and Statement Triggers
# BEFORE and AFTER Triggers
# INSTEAD OF Triggers
# Triggers on System Events and User Events

A row trigger is fired each time the table is affected by
the triggering statement. A statement trigger is fired once
on behalf of the triggering statement.

BEFORE triggers run the trigger action before the triggering
statement is run. AFTER triggers run the trigger action
after the triggering statement is run.

INSTEAD OF triggers provide a transparent way of modifying
views that cannot be modified directly through DML
statements (INSERT, UPDATE, and DELETE).

how to escape special characters in sql statements? : Sql dba

1034

---

What is the difference between clustered and non-clustered indexes?

1085

---

What does plv msg allows you to do?

1137

---

What is difference between table and view?

1048

---

What is Histogram?

1554

---

List out the acid properties and explain?

949

---

What is composite primary key in sql?

993

---

What are sql triggers used for?

992

---

Define commit, rollback and savepoint?

1021

---

How do I count rows in sql query?

986

---

What is use of term?

1059

---

What are the operators used in select statements?

1054

---

Is there a 64 bit version of ssms?

956

---

Write an sql query to select all records from the table?

1022

---

what is a view? : Sql dba

1081

---