Answer / rafi.sk

A trigger is a SQL procedure that initiates an action when
an event (INSERT, DELETE or UPDATE) occurs. Triggers are
stored in and managed by the DBMS.Triggers are used to
maintain the referential integrity of data by changing the
data in a systematic fashion. A trigger cannot be called or
executed; the DBMS automatically fires the trigger as a
result of a data modification to the associated table.
Triggers can be viewed as similar to stored procedures in
that both consist of procedural logic that is stored at the
database level. Stored procedures, however, are not event-
drive and are not attached to a specific table as triggers
are. Stored procedures are explicitly executed by invoking
a CALL to the procedure while triggers are implicitly
executed. In addition, triggers can also execute stored
procedures.
Nested Trigger: A trigger can also contain INSERT, UPDATE
and DELETE logic within itself, so when the trigger is
fired because of data modification it can also cause
another data modification, thereby firing another trigger.
A trigger that contains data modification logic within
itself is called a nested trigger.

Answer / gopi

A trigger is a SQL procedure that initiates an action when
an event (INSERT, DELETE or UPDATE) occurs. Triggers are
stored in and managed by the DBMS.Triggers are used to
maintain the referential integrity of data by changing the
data in a systematic fashion. A trigger cannot be called or
executed; the DBMS automatically fires the trigger as a
result of a data modification to the associated table.
Triggers can be viewed as similar to stored procedures in
that both consist of procedural logic that is stored at the
database level. Stored procedures, however, are not event-
drive and are not attached to a specific table as triggers
are. Stored procedures are explicitly executed by invoking
a CALL to the procedure while triggers are implicitly
executed. In addition, triggers can also execute stored
procedures.

1 01 101 01010

0 Answers  

---

What is log ldf?

0 Answers  

---

syntex of insert

7 Answers  

---

Characterize join and name diverse sorts of joins?

0 Answers  

---

What would be the Expected Salary For SQL Server Developer for 3 years exp. as per indian market?

7 Answers  

---

What is the difference between resultset and resultsetmetadata?

0 Answers  

---

How global temporary tables are represented and its scope?

0 Answers  

---

What is store procedure?

0 Answers  

---

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

0 Answers  

---

How to delete existing rows in a table?

0 Answers  

---

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

---

How to retrieve range of 10th rows to 20 th rows from total rows from a database table.? (Not from Dataset)

10 Answers   Cognizant, Infosys,

---