Answer / vani

Instead of triggers are the procedures that execute in
place of Data Manipulation language (DML)statement on a
table.

for example, if i have INSTEAD-OF-UPDATE Trigger on
TableA,and i execute an update statement on that table,the
code in the INSTEAD-OF-TRIGGER will be executed instead of
the update statement that I executed.

Answer / s.vanitha

The INSTEAD OF triggers execute instead
of the original data modification. INSTEAD OF trigger are
allowed for both tables and views.

Answer / apparao akki

None of the above answers are correct..

The Main objective of INSTEAD OF TRIGGERS is.. To handling
the complexity of View.,i.e; to manipulating the
non-updateable views(the views that have created by many
tables with help of joins, Group by operators or set operator's)

if u need more .. contact on my mail:

apparao.akki@oracle.com

Explain concepts of analysis services?

0 Answers  

---

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

0 Answers  

---

How to count rows with the count(*) function in ms sql server?

0 Answers  

---

How to invoke a trigger on demand?

0 Answers  

---

i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to thilakvinoth13@gmail.com

6 Answers  

---

what is IDE,DMV in sql server?

1 Answers   Value Labs,

---

How to drop existing indexes in ms sql server?

0 Answers  

---

Explain steps of normalization?

0 Answers  

---

when inserting to a table how many rows will be effected using triggers

2 Answers  

---

Explain identity in sql server?

0 Answers  

---

how many type of indexing in database?

0 Answers   IBM,

---

List some case manipulation functions in sql?

0 Answers  

---