Explain Trigger with an example?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

You want to implement the one-to-one relationship while designing tables. How would you do it?

759


What are magic tables in sql server?

839


What is instead of trigger sql server?

715


How do you improve the performance of a SQL Azure Database?

129


what is a schema in sql server 2005? : Sql server database administration

746


Can I delete event logs?

743


Would you store your query in a ssrs report or a database server? State the reason why?

134


Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

704


how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

707


What do you mean by subquery?

795


What is bookmark link in ssrs?

155


Why do we need different type of parameter?

806


OPTIMIZATION OF SP,CURSOR,TRIGGERS

2454


What are the types of table?

781


What are the advantages of sql azure?

134