Groups > comp.databases.ms-sqlserver > #945

Re: Trigger help

From	Johnnyb <john.lutheran@gmail.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Trigger help
Date	2012-03-30 07:35 -0700
Organization	http://groups.google.com
Message-ID	<4510088.2296.1333118153447.JavaMail.geo-discussion-forums@pbjk8> (permalink)
References	<11931752.1474.1333025246004.JavaMail.geo-discussion-forums@pbjv6> <1935751.3379.1333061218074.JavaMail.geo-discussion-forums@vbgu10>

Show all headers | View raw

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ó:
> > 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.
> 
> You cannot make the trigger fire when a particular data is set, it will fire 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 
> [for|after] update
> as 
> begin
> 
> end

That is kind of what I meant, I just didn't have the terminology correct. Thanks!

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Trigger help Johnnyb <john.lutheran@gmail.com> - 2012-03-29 05:47 -0700
  Re: Trigger help Johnnyb <john.lutheran@gmail.com> - 2012-03-30 07:35 -0700
  Re: Trigger help bradbury9 <ray.bradbury9@gmail.com> - 2012-03-29 15:46 -0700
  Re: Trigger help Erland Sommarskog <esquel@sommarskog.se> - 2012-04-02 23:45 +0200
    Re: Trigger help Johnnyb <john.lutheran@gmail.com> - 2012-04-02 15:04 -0700
      Re: Trigger help Erland Sommarskog <esquel@sommarskog.se> - 2012-04-03 07:33 +0000
    Re: Trigger help Gene Wirchenko <genew@ocis.net> - 2012-04-02 20:52 -0700
      Re: Trigger help Erland Sommarskog <esquel@sommarskog.se> - 2012-04-03 07:26 +0000
        Re: Trigger help Johnnyb <john.lutheran@gmail.com> - 2012-04-03 05:03 -0700
        Re: Trigger help Gene Wirchenko <genew@ocis.net> - 2012-04-03 08:17 -0700
    Re: Trigger help Johnnyb <john.lutheran@gmail.com> - 2012-04-04 07:05 -0700
      Re: Trigger help Erland Sommarskog <esquel@sommarskog.se> - 2012-04-04 23:45 +0200
      Re: Trigger help Gene Wirchenko <genew@ocis.net> - 2012-04-04 14:58 -0700
        Re: Trigger help Erland Sommarskog <esquel@sommarskog.se> - 2012-04-05 09:08 +0200
          Re: Trigger help Johnnyb <john.lutheran@gmail.com> - 2012-04-05 06:06 -0700
            Re: Trigger help Gene Wirchenko <genew@ocis.net> - 2012-04-05 08:24 -0700
            Re: Trigger help Erland Sommarskog <esquel@sommarskog.se> - 2012-04-05 23:51 +0200
          Re: Trigger help Gene Wirchenko <genew@ocis.net> - 2012-04-05 08:19 -0700

csiph-web