triggers

[dandamudi padma]

hi i had to create Rowlevel triggers and my req is-- if a new row is added in table1 then the same current row has to be updated in my table2.please can anybody help me padma

[DerekFL]

CREATE TRIGGER sdfsd ON Table1 FOR UPDATE IF (UPDATE(Column1) UPDATE Table2 SET Column1 = i.Column1 FROM Table2 t2 INNER JOIN INSERTED i ON i.RowID = t2.RowID

[DerekFL]

dandamudi padma wrote:

if a new row is added in table1

Did you mean when a row is UPDATE same row has to be updated on table2?

[dandamudi padma]

thanks for ur reply but what i mean is if a row is inserted in table1 after insert the same row has to be Inserted in table2. can u give solution for this Regards padma padma