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
Explain “not null constraint” in sql server?
How to modify an existing stored procedure in ms sql server?
Is mysql better than sql server?
How fixed length strings are truncated and padded?
Do you know nested transaction?
What are the difference between primary key and unique key? : sql server database administration
What is the osql utility?
How many types of attribute relationships are there? : sql server analysis services, ssas
What is a group function explain with an example?
How to move database physical files in ms sql server?
What part does database design plays a role in performance of an sql server-based application?
How to concatenate two binary strings together?
What are the various editions of sql server 2017 that are available in the market?
What are approximate numeric data types in ms sql server?
What is use of except clause? How it differs from not in clause?
