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 to implement service broker?
how to do partition in sqlserver
What are different types of constraints?
What is inline table-value user-defined function?
What is the difference between a function and a stored procedure?
how would you improve etl (extract, transform, load) throughput?
Explain the cursor lock types?
Explain the use of keyword with encryption. Create a store procedure with encryption?
What is data compression? : sql server database administration
Where cross join is used?
Do you know exporting and importing utility?
What it means to be triggered?
Introduction of rollup clause using sum and group by clause?
What are drilldown reports?
Explain what is it unwise to create wide clustered index keys?
