Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!border3.nntp.dca.giganews.com!border1.nntp.dca.giganews.com!nntp.giganews.com!npeer01.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail From: bradbury9 Newsgroups: comp.databases.ms-sqlserver Subject: Re: Trigger help Date: Thu, 29 Mar 2012 15:46:57 -0700 (PDT) Organization: http://groups.google.com Lines: 15 Message-ID: <1935751.3379.1333061218074.JavaMail.geo-discussion-forums@vbgu10> References: <11931752.1474.1333025246004.JavaMail.geo-discussion-forums@pbjv6> NNTP-Posting-Host: 37.133.94.90 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Trace: posting.google.com 1333061586 2605 127.0.0.1 (29 Mar 2012 22:53:06 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Thu, 29 Mar 2012 22:53:06 +0000 (UTC) In-Reply-To: <11931752.1474.1333025246004.JavaMail.geo-discussion-forums@pbjv6> Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=37.133.94.90; posting-account=jIl9nQoAAAA9P37IIqQq64yAx-2NQYiu User-Agent: G2/1.0 X-Received-Bytes: 1691 Xref: csiph.com comp.databases.ms-sqlserver:946 El jueves 29 de marzo de 2012 14:47:26 UTC+2, Johnnyb escribi=F3: > I need to create a trigger that will fire when particular text shows up i= n a particular column. Then I need to copy that row to another table. Not s= ure how to do this. Any help would be greatly appreciated. You cannot make the trigger fire when a particular data is set, it will fir= e always. The way to do it the way you like it is make a trigger with an IF= inside and checking if that column has the text desired. Create trigger trigger_name on table_name=20 [for|after] update as=20 begin end