home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 18,576 of 19,505   
   Gene Wirchenko to esquel@sommarskog.se   
   Re: Trigger help   
   03 Apr 12 08:17:49   
   
   From: genew@ocis.net   
      
   On Tue, 3 Apr 2012 07:26:12 +0000 (UTC), Erland Sommarskog   
    wrote:   
      
   >Gene Wirchenko (genew@ocis.net) writes:   
   >>      Why would this be relevant since the trigger is for after the   
   >> insertion?  Assuming the above is correct, I think that I am missing a   
   >> nuance.   
   >   
   >CREATE TRIGGER tri ON tbl AFTER INSERT, UPDATE AS   
   >   
   >Notice the word UPDATE?   
      
        Yes.  Why does an after-update trigger make a difference about if   
   the condition exists before?   
      
   [snip]   
      
   Sincerely,   
      
   Gene Wirchenko   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca