what is meant by trigger?
Answers were Sorted based on User's Feedback
Answer / mrniceksa
A trigger is a special kind of stored procedure that goes
into effect when you modify data in a specified table using
one or more data modification operations: UPDATE, INSERT,
or DELETE. Triggers can query other tables and can include
complex SQL statements. They are primarily useful for
enforcing complex business rules or requirements. For
example, you could control whether to allow an order to be
inserted based on a customer's current account status.
| Is This Answer Correct ? | 46 Yes | 7 No |
Answer / bgg
trigger is something which is executed when some specified
event occurs.
two main specifications are-
1.when the trigger should be executed(event)
2.what action must be taken when this event occurs
| Is This Answer Correct ? | 15 Yes | 5 No |
Answer / sagaya maria virgin
a trigger is a statement that system execute automatically
as a side effect of a modification of database.
| Is This Answer Correct ? | 9 Yes | 3 No |
Answer / dinesh kumar
Trigger can be defined as a action that is performed on
data when event occur. Here action can modify data from
database, insert data into database etc.
| Is This Answer Correct ? | 9 Yes | 5 No |
Answer / srikanth
A trigger is a special kind of stored procedure that goes
into effect when you modify data in a specified table using
one or more data modification operations: UPDATE, INSERT,
or DELETE.
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / a.palanisamy
A trigger is a special kind of stored procedure that goes
into effect when you modify data in a specified table using
one or more data modification operations: UPDATE, INSERT,
or DELETE. in future use u can get old data from specified table
| Is This Answer Correct ? | 0 Yes | 1 No |
technical interview questions and process
What binary value will be internally stored for NULL for the type S9(1) COMP 3 in mainframe
How to create a new dataset only duplicate observations in proc sort procedure?
ok how would i do the following extract from a file i have ssns = 267907230 which are in column 7 into a separate data set then create a 2nd job step to extract from the data set created the following "fund code" which is in column 31 and is 113 into yet another data set
How many types of list exist in the HTML
what are stubs related to foxpro?
What is the difference between compiled and interpreted languages?
i want to improve my english vocab for racking campus written exam plz tell me best book for prepration......
What is the difference between DECISION COVERAGE(DC) and MODIFIED CONDITION/DECISION COVERAGE(MCDC)?
Iam using Microsoft Visual Studio to create a system for mobile store I want to know how to calculate mobile price that the customer buy and how to reduce quantity from the data base that we have for mobile .And also how to calculate revnue for each mobile and revnue for the total mobile
How will you prove that java swing is multithreaded?
explain how to make a control visible and invisible during runtime