Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.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: Johnnyb Newsgroups: comp.databases.ms-sqlserver Subject: Re: Trigger help Date: Fri, 30 Mar 2012 07:35:53 -0700 (PDT) Organization: http://groups.google.com Lines: 19 Message-ID: <4510088.2296.1333118153447.JavaMail.geo-discussion-forums@pbjk8> References: <11931752.1474.1333025246004.JavaMail.geo-discussion-forums@pbjv6> <1935751.3379.1333061218074.JavaMail.geo-discussion-forums@vbgu10> NNTP-Posting-Host: 68.35.50.243 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Trace: posting.google.com 1333118154 7625 127.0.0.1 (30 Mar 2012 14:35:54 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Fri, 30 Mar 2012 14:35:54 +0000 (UTC) In-Reply-To: <1935751.3379.1333061218074.JavaMail.geo-discussion-forums@vbgu10> Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=68.35.50.243; posting-account=kYW--QoAAABRuO6dTOz2QITtLsB-PRVZ User-Agent: G2/1.0 X-Received-Bytes: 1935 Xref: csiph.com comp.databases.ms-sqlserver:945 On Thursday, March 29, 2012 4:46:57 PM UTC-6, bradbury9 wrote: > 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= in a particular column. Then I need to copy that row to another table. Not= sure how to do this. Any help would be greatly appreciated. >=20 > You cannot make the trigger fire when a particular data is set, it will f= ire 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. >=20 > Create trigger trigger_name on table_name=20 > [for|after] update > as=20 > begin >=20 > end That is kind of what I meant, I just didn't have the terminology correct. T= hanks!