Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL SQL-Server CURSOR T-SQL , +
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 5:26am
Belial092.6K
Edited 26-Sep-12 6: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 at 26-Sep-12 11:48am
   
Yep - my 5.
 
On a sidenote, I hate triggers!
Belial09 at 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
0 Sergey Alexandrovich Kryukov 555
1 Kornfeld Eliyahu Peter 409
2 Maciej Los 369
3 DamithSL 196
4 OriginalGriff 188
0 OriginalGriff 6,353
1 DamithSL 4,854
2 Maciej Los 4,466
3 Kornfeld Eliyahu Peter 4,058
4 Sergey Alexandrovich Kryukov 3,897


Advertise | Privacy | Mobile
Web02 | 2.8.141220.1 | Last Updated 26 Sep 2012
Copyright © CodeProject, 1999-2014
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