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

How can you ensure that the database and sql server based application perform well?

823


What is a result set object returned by mssql_query()?

783


What are the purposes and advantages stored procedure?

716


How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

739


Do you know what guidelines should be followed to help minimize deadlocks?

750


How to retrieve error messages using mssql_get_last_message()?

761


What is the difference between a clustered index and a non-clustered index?

745


How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

749


How do I make a resultset scrollable?

736


What is nested transaction?

807


What is model database in sql server?

815


How do I create a stored procedure in dbml?

716


How to use subqueries in the from clause in ms sql server?

861


Difference between 2NF &3NF ?

871


what's the difference between a primary key and a unique key? : Sql server database administration

713