What is Triggers..and what r the type of triggers
2006-12-28 12:45:23 · 3 answers · asked by Ramana 1 in Computers & Internet ➔ Programming & Design
There are two types of triggers. Update trigger and Insert trigger.
You define trigger on a table. On this definition, you say what you want to happen when someone either updates or inserts a row into this table. Once this is done and enabled, every time someone does INSERT or UPDATE into this table, actions you predefine will happen.
2006-12-28 12:53:58 · answer #1 · answered by tkquestion 7 · 0⤊ 0⤋
A trigger is an event trigger. when data is updated or inserted into a table.
The trigger is either BEFORE or AFTER.
The use of a BEFORE trigger on and UPDATE is that you want to copy to original data to another table for sake of keeping a history or data changes.........so before the update takes place, copy the original record to archive and then allow the update.
An AFTER trigger is usefull on an insert to copy the new info to archive for historic record keeping.
2006-12-28 14:41:49 · answer #2 · answered by Jeffrey F 6 · 0⤊ 0⤋
triggers are the small programs which evoke when some kinda specific event(s) take place..
2006-12-28 12:54:53 · answer #3 · answered by dumb007 1 · 0⤊ 0⤋