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
What are the advantages of using a stored procedure?
What are “lost updates”?
What is the xml datatype?
Explain how many types of relationship?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
Explain how to send email from sql database?
how we use window authentication connection with sql server.?
Your table has a large character field there are queries that use this field in their search clause what should you do?
What is the definition for sql server 2000?
What are the new scripting capabilities of ssms? : sql server management studio
how to invoke a trigger on demand? : Sql server database administration
Can you force a query to use a specific index?
What is table constraint?
In case you have filters in your report, when filters will be applied in cached report instance?
Difference between aggregate functions of sql?
