wat is mean by trigger?.......normally wat use......when
trigger used in sql...........
plz cleary say with example.......
- 2 Answers
- 5648 Views
- TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / vimal p.s
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 ? | 15 Yes | 1 No |
Post New Answer View All Answers
Determine how to use the inserted and deleted pseudo tables?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
What is usually the first word in a sql query?
How can you check the version of sql server?
Explain indexed views and partitioned view with their syntax.
What are data regions?
What are the different types of collation sensitivity?
can you implement data mining in SSRS?
How to create function without parameter in sql server?
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
what is database replication? : Sql server database administration
What is sql server 2000 work load governor?
Explain what you mean by 3 tier architecture.
What is cte (common table expression)?
Explain mixed authentication mode of sql server?
