Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!eternal-september.org!feeder.eternal-september.org!mx04.eternal-september.org!.POSTED!not-for-mail From: Erland Sommarskog Newsgroups: comp.databases.ms-sqlserver Subject: Re: Trigger help Date: Tue, 3 Apr 2012 07:26:12 +0000 (UTC) Organization: Erland Sommarskog Lines: 21 Message-ID: References: <11931752.1474.1333025246004.JavaMail.geo-discussion-forums@pbjv6> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Injection-Date: Tue, 3 Apr 2012 07:26:12 +0000 (UTC) Injection-Info: mx04.eternal-september.org; posting-host="G7+Jz22XqYCG8C6rb1H3YA"; logging-data="13764"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1952VfLLpR5O37iH7P/AZp4" User-Agent: Xnews/2005.10.03 Mime-proxy/1.4.c.4 (Win32) Cancel-Lock: sha1:dqNnFdtv/yoAX/I/f3ruhIPUs24= Xref: csiph.com comp.databases.ms-sqlserver:950 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? True, I don't know whether Johnnyb wants to handle updates. He only says "when particular text shows up in a particular column". Really what mean I don't know. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx