Click here to Skip to main content
14,921,505 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hello,

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

SQL
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
Updated 26-Sep-12 5:05am
v2

1 solution

why cant you just say
SQL
insert into newtable( field1,field2) select field1,field2 from inserted
   
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)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900