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.

What is the difference between a local and a global variable?

5 Answers  

---

What is the difference between DTS and SSIS?

3 Answers   Allianz,

---

How to delete an existing row with delete statements in ms sql server?

0 Answers  

---

What are different backups available in sql server?

0 Answers  

---

Why people hate cursor?

0 Answers  

---

What is the difference between OLEDB and ODBC

4 Answers   CFCI,

---

when we use function instead of procedure? plz tell me the situation with ex?

3 Answers   IBM,

---

How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.

8 Answers   Intelenet,

---

Explain the difference between functions and stored procedures in sql server?

0 Answers  

---

What is the partitioning method?

0 Answers  

---

I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000

17 Answers   HCL, IBM,

---

what types of replication are supported in sql server? : Sql server database administration

0 Answers  

---