1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Explain Trigger with an example?

Question Posted / grj

Answers were Sorted based on User's Feedback



Explain Trigger with an example? ..

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.

Is This Answer Correct ?    36 Yes 6 No

Explain Trigger with an example? ..

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.

Is This Answer Correct ?    6 Yes 10 No

Post New Answer

More SQL Server Interview Questions

What is the difference between DataRow.Delete() and DataRow.Remove()?

0 Answers  

What is key set driven?

0 Answers  

How will you collect the date from current date to last older 6 days date in sql server 2005

4 Answers  

Explain log shipping and mention its advantages.

0 Answers  

How do you find the error, how can you know the number of rows effected by last SQL statement?

2 Answers  




Explain having clause?

0 Answers  

What are key constraints?

0 Answers  

What is self contained scalar sub query?

0 Answers  

How can sql server instances be hidden? : sql server security

0 Answers  

How to generate random numbers with the rand() function in ms sql server?

0 Answers  

What is an expensive query?

0 Answers  

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

5 Answers  

For more SQL Server Interview Questions Click Here
Categories