Interested to Buy Any Domain ? << Click Here >> for more details...
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
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
Which are the two editions in which SQL Azure database available?
How to search for a string in all stored procedure in sql server?
What is the default server name for sql server?
What is lock escalation and what is its purpose?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
Can you explain what is sql server english query?
explain different types of constraints? : Sql server database administration
What extended events?
How check triggers in sql server?
what are the different ways to return the rowcount of a table?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
What is temporal data type?
How many types of the database links?
What is transaction server distributed transaction?
