Interested to Buy Any Domain ? << Click Here >> for more details...
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
How do database indexes work?
Why use “in” clause in sql server?
What is implicit cursors?
System requirements for sql server 2005 express edition?
What are the kinds of subquery?
How do I install sql server?
Why transaction is important?
Which sql server table is used to hold the stored procedure script?
How to generate create function script on an existing function?
What does asynchronous call backs means?
can we have a nested transaction? : Sql server database administration
What is analysis service repository?
When I run the sql server 2000 setup, it just hangs. What do I do?
What is 1nf 2nf and 3nf?
How do you migrate data from mssql server to azure?
