Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aethertan
Starting Member
6 Posts |
 Posted - 2002-07-08 : 01:57:06
|
| Hi everybodyHows evryone today. Wonderfull day today isn't it??Does anybody have ant clue on what the f**k Triggers and cascading referantial actions are. PLEASE HELP IF YOU DO!!!!!!!I beg of thee to help thy understand as much as I can about these strange and wonderful things called Triggers and cascading referantial actions.What are they, whay are they used, when are they used, what re the benfits of using them? Thanks a millionC yaAetheran |
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2002-07-08 : 02:16:31
|
| Aetheran,Read BOL (Books on Line)DavidM"SQL-3 is an abomination.." |
 |
|
|
BigRetina
Posting Yak Master
144 Posts |
Posted - 2002-07-08 : 06:51:25
|
| Triggers are routines that are "FIRED" or started automatically when a certian action takes place..such as a DELETE operation or an INSERT operation. U can write a trigger and associate it with table for a delete operation for example..so whenever a delete takes place on the table the TRIGGER routine will fire and get executed.Triggers can be used to maintain refrential integrity. For example deleting children records when a parent record is deleted!HTHSalute.. |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
|
|
|
|
|
Triggers and cascading referantial actions