Need an example for Indirect Recursive Trigger?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » T-SQL (SS2K8) » Need an example for Indirect Recursive...

Need an example for Indirect Recursive Trigger?

Rate Topic

Display Mode

Topic Options

Author

Message

jmohan1984.tn.ind

Posted Tuesday, December 18, 2012 5:19 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, December 18, 2012 7:46 AM
Points: 2, Visits: 2

hi, I need an example simple indirect recursive trigger.
Thanks.

Post #1397713

anthony.green

Posted Tuesday, December 18, 2012 5:32 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

Simple thing would be imagine 2 tables, with 1 column.

Trigger on each table after the insert of a value into the column

Insert into Tab1 fires Trig1 which inserts the value into Tab2.

Tab2 trigger fires which inserts the value back to Tab1, which caused the trigger to fire on Tab1

And it goes on and on and on in an endless loop

http://msdn.microsoft.com/en-us/library/ms190739%28v=sql.100%29.aspx

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1397717

opc.three

Posted Wednesday, December 19, 2012 12:47 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 7:22 AM
Points: 6,693, Visits: 11,707

jmohan1984.tn.ind (12/18/2012)

hi, I need an example simple indirect recursive trigger.
Thanks.

Did you make it beyond the phone interview?

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1398631

dwain.c

Posted Wednesday, December 19, 2012 5:35 PM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 12:42 AM
Points: 2,338, Visits: 3,158

opc.three (12/19/2012)

jmohan1984.tn.ind (12/18/2012)

hi, I need an example simple indirect recursive trigger.
Thanks.

Did you make it beyond the phone interview?

ROTFLMAO! +1

No loops! No CURSORs! No RBAR! Hoo-uh!

INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?

Need to UNPIVOT? Why not CROSS APPLY VALUES instead?
Since random numbers are too important to be left to chance, let's generate some!
Are you too recursively challenged?
Splitting strings based on patterns can be fast!

Post #1398720

« Prev Topic | Next Topic »

Permissions