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 ««12

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


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 3:41 AM
Points: 1,699, Visits: 1,116
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: Monday, September 15, 2014 11:54 AM
Points: 4,427, Visits: 3,423
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: Today @ 10:15 AM
Points: 2,333, Visits: 1,393
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
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 5:38 AM
Points: 823, Visits: 154
Great question.....
Post #1450881
Posted Thursday, May 9, 2013 1:12 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 6:56 PM
Points: 1,727, Visits: 760
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: Today @ 8:29 AM
Points: 13,741, Visits: 10,716
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


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:32 PM
Points: 21,755, Visits: 15,459
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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1451329
Posted Wednesday, May 15, 2013 2:40 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 2:20 PM
Points: 2,136, Visits: 870
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, September 4, 2014 7:40 AM
Points: 3,546, Visits: 2,652
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 ««12

Permissions Expand / Collapse