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

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

Re: Trigger help

Show all headers | View raw

OK, here's more information:

The table I'm adding this trigger to is replicated from another server. When I add the trigger:

USE [NDII_MAIN]
GO
/****** Object:  Trigger [dbo].[880IOT]    Script Date: 04/04/2012 07:54:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE TRIGGER 
    [dbo].[880IOT]
ON 
    [dbo].[logfile0]
FOR INSERT, UPDATE 
AS
  BEGIN
    SET NOCOUNT ON
      INSERT INTO [DB02TSSNT].[Test].[dbo].[880io]
      (
    eventcode,
    cardname,
	eventnumber,
	eventdatetime,
	pointname
      )
    SELECT
    eventcode,
    cardname,
	eventnumber,
	eventdatetime,
	pointname
    FROM INSERTED
    WHERE POINTNAME LIKE 'XXXXX' OR POINTNAME LIKE 'YYYYY'
END

It stops the replication. What am I doing wrong?



On Monday, April 2, 2012 3:45:21 PM UTC-6, Erland Sommarskog wrote:
> Johnnyb (john.lutheran@gmail.com) writes:
> > 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. 
> 
> CREATE TRIGGER tri ON tbl AFTER INSERT, UPDATE AS
> IF EXISTS (SELECT *
>            FROM  inserted
>            WHERE  col LIKE '%particular text%')
> BEGIN
>    -- Do something here.
> END
> 
> 
> inserted holds the inserted rows, or in case of an UDPATE statement, the
> updated rows after the UPDATE. 
> 
> Don't forget to consider what should happen if the text appears both 
> before and after the update.
> 
> -- 
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
> 
> Links for SQL Server Books Online:
> SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
> SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

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