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
What are ddl triggers and types of ddl trigger?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
How can we use ConnectorJ JDBC Driver with MS SQL?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
How to list all triggers in the database with sys.triggers in ms sql server?
What is the difference between stored procedure and user defined functions?
Why should we go for stored procedures? Why not direct queries?
How to convert a table data in XML format in sql server?
Explain an automatic checkpoint
How many categories of data types used by sql server?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
what is database replicaion? : Sql server database administration
How to test subquery results with the exists operator?
What is raid, and how it can influence database performance?
what happens on checkpoint? : Sql server database administration
