Explain Trigger with an example?
Answers were Sorted based on User's Feedback
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 |
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 |
What is read uncmmited?
what is syntex second or third highest salary. thanks & Regards Dhirendra sinha
Define primary key?
SYNTAX FOR VIEWS WITH EXAMPLE HOW TO LINK TWO TABLES
what stored procedure can you use to display the current processes? : Sql server administration
select top 5 * from emp order by newid() my question is , how this query get executed?
Which table keeps the locking information?
what are the new features of sql server 2005?
8 Answers HP, Keane India Ltd,
How to write a query with a right outer join in ms sql server?
What is the parse query button used for?
Tell me the phases a transaction has to undergo?
What is 3nf normalization form?