Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


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

Trigger help

Path csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!eternal-september.org!feeder.eternal-september.org!goblin1!goblin.stu.neva.ru!nrc-news.nrc.ca!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 Johnnyb <john.lutheran@gmail.com>
Newsgroups comp.databases.ms-sqlserver
Subject Trigger help
Date Thu, 29 Mar 2012 05:47:26 -0700 (PDT)
Organization http://groups.google.com
Lines 1
Message-ID <11931752.1474.1333025246004.JavaMail.geo-discussion-forums@pbjv6> (permalink)
NNTP-Posting-Host 198.102.153.2
Mime-Version 1.0
Content-Type text/plain; charset=ISO-8859-1
X-Trace posting.google.com 1333025372 13286 127.0.0.1 (29 Mar 2012 12:49:32 GMT)
X-Complaints-To groups-abuse@google.com
NNTP-Posting-Date Thu, 29 Mar 2012 12:49:32 +0000 (UTC)
Complaints-To groups-abuse@google.com
Injection-Info glegroupsg2000goo.googlegroups.com; posting-host=198.102.153.2; posting-account=kYW--QoAAABRuO6dTOz2QITtLsB-PRVZ
User-Agent G2/1.0
X-Received-Bytes 1101
Xref csiph.com comp.databases.ms-sqlserver:944

Show key headers only | View raw


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.

Back to comp.databases.ms-sqlserver | Previous | NextNext 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