Answer / nilesh

There are 2 types of triggers as per the execution goes
they are ROW LEVEL and STATEMENT LEVEL TRIGGERS

Then as per action triggers can be executed for three
actions as INSERT, UPDATE and DELETE

and trigger can also be executed before the action or after
the action . So with this we can have 12 diffrent triggers
they are: (6 Row level, 6 statement level)

ROW LEVEL
AFTER INSERT , BEFORE INSERT (2 Nos.)
AFTER UPDATE , BEFORE UPDATE (2 Nos.)
AFTER DELETE , BEFORE DELETE (2 Nos.)

STATEMENT LEVEL
AFTER INSERT , BEFORE INSERT (2 Nos.)
AFTER UPDATE , BEFORE UPDATE (2 Nos.)
AFTER DELETE , BEFORE DELETE (2 Nos.)

Answer / biswajit biswal

We can specified 28 Database triggers on a single table.

Before Row level insert
After Statement level update
Delete
insert or update
update or delete
insert or delete
insert or update or delete

2*2*7=28

how can we write a column values horizontal by using sql stmt; ex: select name from table_name;(actual output) a b c d require output is a b c d

5 Answers   Honeywell, Interact,

---

What do you mean by stored procedures? How do we use it?

0 Answers  

---

What is a file delimiter?

0 Answers  

---

In a package if we have 10 procedures or functions,How to know which will execute first?

1 Answers   Sollet Soft,

---

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

0 Answers  

---

Explain what is a field in a database and record in a database?

0 Answers  

---

What is the trigger in sql?

0 Answers  

---

What is NOCOPY?

6 Answers   DELL,

---

What are all the different normalizations?

0 Answers  

---

What has stored procedures in sql?

0 Answers  

---

What is a rank in sql?

0 Answers  

---

i have xml source. xml source having lacks of records. i want extract/retrive xml source data using sql query. please tell me how to write query.

4 Answers   TCS,

---