Click here to Skip to main content
12,947,643 members (61,683 online)
Rate this:
 
Please Sign up or sign in to vote.
Hello,

is there any chance of creating a trigger like this one:

CREATE TRIGGER tri_Test ON TESTTABLE FOR UPDATE NOT FOR REPLICATION AS
    SET NOCOUNT ON
        BEGIN
 
            DECLARE @Field1 varchar(31)
            DECLARE @Field2 bigint
 
            SELECT @Field1 = Field1 FROM inserted;
            SELECT @Field2 = Field2 FROM inserted;
 
            INSERT INTO NEWTABLE (Field1,Field2)
            VALUES (@Field1, @Field2)
 
        END
GO


for multiple Rows in "inserted" but without the use of a cursor?
I googled a lot and played with WHILE and @@rowcount but could not find a solution yet.

A sample would be nice.


EDIT:
my goal is not to "mirror" the tables.


thank you
Posted 26-Sep-12 4:26am
Belial092.7K
Updated 26-Sep-12 5:05am
v2

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

why cant you just say
insert into newtable( field1,field2) select field1,field2 from inserted
  Permalink  
Comments
Dylan Morley 26-Sep-12 11:48am
   
Yep - my 5.

On a sidenote, I hate triggers!
Belial09 27-Sep-12 2:25am
   
To easy to be true Santhosh.
Sometimes it may be better to take a break :)

thanks a lot!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 5,134
CHill60 3,275
Maciej Los 2,563
Jochen Arndt 1,935
ppolymorphe 1,795


Advertise | Privacy | Mobile
Web02 | 2.8.170518.1 | Last Updated 26 Sep 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100