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 08, 2013 8:56 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Today @ 2:16 AM
Points: 1,498, Visits: 981
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 08, 2013 10:28 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 10:52 AM
Points: 4,252, Visits: 3,335
Another great one from Tom. Thanks to both Tom for the question and to Hugo for his analysis.
Post #1450684
Posted Wednesday, May 08, 2013 10:47 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, March 10, 2014 5:44 PM
Points: 2,225, Visits: 1,258
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 08, 2013 10:54 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 4:54 AM
Points: 655, Visits: 134
Great question.....
Post #1450881
Posted Thursday, May 09, 2013 1:12 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 12:35 AM
Points: 1,582, Visits: 696
Good question - thanks had to think twice before answering

Hope this helps...

Ford Fairlane
Rock and Roll Detective





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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:17 PM
Points: 12,232, Visits: 9,209
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 09, 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 @ 1:10 PM
Points: 20,485, Visits: 14,141
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


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 1:34 AM
Points: 1,950, Visits: 817
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: Wednesday, April 16, 2014 6:04 AM
Points: 3,517, Visits: 2,606
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, October 31, 2013 11:22 AM
Points: 160, Visits: 231
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