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 @ 2:53 AM
Points: 1,658, Visits: 1,088
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: Today @ 8:50 AM
Points: 4,425, Visits: 3,417
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 @ 5:13 PM
Points: 2,290, Visits: 1,343
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
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 2:42 AM
Points: 792, Visits: 153
Great question.....
Post #1450881
Posted Thursday, May 9, 2013 1:12 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, August 11, 2014 12:00 AM
Points: 1,691, Visits: 757
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 @ 9:28 AM
Points: 13,570, Visits: 10,447
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: Today @ 3:27 PM
Points: 21,631, Visits: 15,289
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: Yesterday @ 7:53 PM
Points: 2,136, Visits: 869
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: Tuesday, August 5, 2014 5:20 AM
Points: 3,546, Visits: 2,651
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: 2 days ago @ 3:11 AM
Points: 160, Visits: 234
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