Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 3:42 AM
Points: 1,980, Visits: 1,302
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


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 9:55 AM
Points: 4,384, Visits: 3,592
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: Wednesday, April 15, 2015 5:59 PM
Points: 2,584, Visits: 1,677
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
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, March 18, 2015 4:24 AM
Points: 1,060, Visits: 168
Great question.....
Post #1450881
Posted Thursday, May 9, 2013 1:12 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, February 22, 2015 10:31 PM
Points: 1,813, Visits: 803
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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 9:05 AM
Points: 14,265, Visits: 12,258
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 LessThanDot.

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: Today @ 1:42 AM
Points: 18,505, Visits: 16,751
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: Sunday, April 12, 2015 3:01 PM
Points: 2,198, Visits: 899
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: Thursday, April 16, 2015 4:48 AM
Points: 3,593, Visits: 2,687
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: Monday, August 25, 2014 10:53 PM
Points: 160, Visits: 235
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