Explain Trigger with an example?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the index requirement in SQL Azure?

86


How you can move data or databases between servers and databases in sql server?

828


Explain trigger and its types?

869


How real and float literal values are rounded?

872


What is rtm version in sql server?

752


on line cluster can we make if yes tell me the procedure

1789


How do we Backup SQL Azure Data?

100


what is the different types of backups available in sql server? : Sql server database administration

701


wat wil hapn if we give the both read and deny read permission to user?

1912


How you would rewrite the sql query to return the customerid sorted numerically?

793


What are the new features of sql server 2008 r2 reporting service?

124


Where the sql logs gets stored?

757


what are the different types of replication you can set up in sql server? : Sql server database administration

801


How you can find out if an index is useful to the optimizer?

691


What is the purpose of the tempdb database?

804