Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

Nested triggers 2 Expand / Collapse
Author
Message
Posted Wednesday, May 8, 2013 8:56 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:57 AM
Points: 2,502, Visits: 1,681
Nice back to basics question, thanks!




(Do I get an extra point for 'most inappropriate comment'? I enjoyed the explanations, my takeaway is avoid triggers in general, especially on views.)
Post #1450628
Posted Wednesday, May 8, 2013 10:28 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:36 PM
Points: 5,174, Visits: 4,323
Another great one from Tom. Thanks to both Tom for the question and to Hugo for his analysis.
Post #1450684
Posted Wednesday, May 8, 2013 10:47 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, January 26, 2016 9:10 AM
Points: 2,602, Visits: 1,694
Really had to think about this one. Thank to both/all for input and explanation.


Not all gray hairs are Dinosaurs!
Post #1450694
Posted Wednesday, May 8, 2013 10:54 PM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Monday, May 16, 2016 11:53 PM
Points: 1,467, Visits: 180
Great question.....
Post #1450881
Posted Thursday, May 9, 2013 1:12 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, January 20, 2016 3:52 PM
Points: 1,818, Visits: 836
Good question - thanks had to think twice before answering

Hope this helps...

Ford Fairlane
Rock and Roll Detective





Post #1450902
Posted Thursday, May 9, 2013 12:07 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 3, 2016 7:09 AM
Points: 15,149, Visits: 13,037
Interesting question, thanks.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1451287
Posted Thursday, May 9, 2013 3:05 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Wednesday, June 22, 2016 2:24 PM
Points: 19,803, Visits: 18,086
Thanks Tom, I tend to learn a fair amount from your questions.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1451329
Posted Wednesday, May 15, 2013 2:40 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 12:39 PM
Points: 2,822, Visits: 1,020
Thanks.

A good thinking and working it through question.

David
Post #1452977
Posted Wednesday, May 22, 2013 1:21 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, May 23, 2016 5:31 AM
Points: 3,615, Visits: 2,774
Very good question. Got few points in my mind.
Post #1455334
Posted Monday, September 16, 2013 8:45 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, January 14, 2016 11:18 AM
Points: 163, Visits: 260
Oh, s***.

Is it a good question? Good question! For me the question was: What exactly is the question?!

Well, I already had troubles to solve the SQL arithmetic, I therefore wasn't aware of the troubles arising when using a view in an INSTEAD OF trigger...

And I am still struggling with it, even with Hugos' explanation...

:-(


________________________________________________________
If you set out to do something, something else must be done first.
Post #1495130
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse