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 insert multiple rows with a subquery?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
What is the purpose of sql profiler in sql server?
what is a transaction? : Sql server database administration
What will be the maximum number of index per table?
What is default constraint?
How would you use user_constraints table in DB?
how can you attach more than 20 ldf files in sql server
What is a View ? Can we insert, Update and delete a view?
How to loop through returning rows?
What is tempdb database? : SQL Server Architecture
What according to you is the difference between mysql and sql server performance?
How to use column default values in insert statements in ms sql server?
What is the difference between a primary key and a unique key? Are they the same?
What is the difference between seek predicate and predicate?
