what is trigger?
Answers were Sorted based on User's Feedback
Answer / shanthi bhushan
Trigger is procedure which is automatically fires when we
modify the data in table(After i.e.,Data Manipulation wiil
be one)
Is This Answer Correct ? | 14 Yes | 0 No |
Answer / naresh
Trigger is just like a storedprocedure but the only
difference is it is automatically call when the event ocour
or fire.
Is This Answer Correct ? | 11 Yes | 2 No |
Answer / srividhya.s
Triggers are simply stored procedures that are executed
automatically by the database whenever
some event (usually a table update) happens.
sample:
CREATE [OR REPLACE]
TRIGGER trigger_name
BEFORE (or AFTER)
INSERT OR UPDATE [OF COLUMNS] OR DELETE
ON tablename
[FOR EACH ROW [WHEN (condition)]]
BEGIN
DBMS_OUTPUT.PUT_LINE(’Ur message to be
displayed ’ :NEW.NAME);
END;
Is This Answer Correct ? | 9 Yes | 1 No |
A trigger is a DB object like proc. or func. stored in data
dictonary. It will fire implicitly with event on which it
written.
Main use of a trigger are
-- we can take backup of data.
-- Can be used for auditing purpose.
-- For applying complex bussiness rule.
Etc.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / srini
Trigger is a special kind of stored procedure executed
certain event occurs.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sudha
trigger is stored procedure it execute the one event
when another event is happenning for example it can do the
insert operation as well as select operation.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / monika mudgal
Trigger are events that perform some action.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / aarthi
trigger is used nto change the control from one state to
another
Is This Answer Correct ? | 1 Yes | 0 No |
What is the difference between executenonquery () and executescalar ()?
I want to ask u that if i add radio button in ado.net form,and how radion button data insert in SQL2005 Database...
Which is the best institute in hyderabad to learn DotNet?
What is data relation?
What is the default view of Data Grid?
Can we connect two dataadapters to same data source using single connection at same time?
types of Store procedure in Sqlserver2000?
What is Data view?
What is csdl entity framework?
What are the several execute methods of ado.net?
What is @@rowcount and with small code snippet explain the usage?
What do you mean by performing asynchronous operation using command object?