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)

Answer / naresh

Trigger is just like a storedprocedure but the only
difference is it is automatically call when the event ocour
or fire.

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;

Answer / roopesh kumar

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.

Answer / srini

Trigger is a special kind of stored procedure executed
certain event occurs.

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.

Answer / monika mudgal

Trigger are events that perform some action.

Answer / aarthi

trigger is used nto change the control from one state to
another

How to Handle the exceptions in Sqlsrver2000

3 Answers   SQL Star,

What is the use of connection object in ado.net?

0 Answers   TryTechnicals Pvt Ltd,

How to add a javaScript function in a datagrid?

0 Answers   C DAC, CDAC,

What is the difference between linq and ado.net?

0 Answers  

Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.

0 Answers  

Define different execute methods of ADO.NET command object ?

0 Answers   NA,

What is a database provider?

2 Answers   BioSys,

What is the difference between data grid and data repeater?

0 Answers  

Which parameter of ConnectionString is used to specify the name of the database?

0 Answers  

Sequence to connect and retrieve data from database useig dataset ?

6 Answers   MMTS,

Is it possible to edit data in Repeater control?

0 Answers  

What are the usages of the command object in ado.net?

0 Answers