SQL ==> Creating a Trigger ?!?!?!?

Question

i need to create a trigger that after inserting a row into table a

gets 2 fields from the inserted row, and insert them into table b

can anyone give me a sample on how to do this?

SQLServer

Answer 1

CREATE TRIGGER trig_addTOTable2

ON table1

FOR INSERT

AS

INSERT INTO tables(fld1,fld2) values( inserted.fld1,inserted.fld2)