Hi all,

I have tbl1 and tbl2 they have the same number of columns.

I'd like to write trigger that every time I insert a new row into the tbl1 it will trigger and insert same row to tbl2.

Ex:

if I insert into tbl1
col1 col2
---- ----
ad bc

then the trigger will insert into tbl2
col1 col2
---- ----
ad bc

I can't think of the way to do. Please anyone who has been there gives me a tip. Thanks.

The 'inserted' pseudo table lists the rows which have been inserted into a table. Thus, code in the trigger along the lines of:
would do the trick, but for a complication when rows are updated.

The 'deleted' pseudo table lists those rows which have been removed. Updates to a table are implemented as a delete and add, so updated rows are in both tables, and if you only care about new rows, you'll want to modify that INSERT so it only selects rows which are not in 'deleted'.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

Hi khautinh,
 Try this:

  create or replace trigger triggername
  BEFORE UPDATE on tb1
  FOR EACH ROW
  begin
    insert into tb2 values(:old.col1,:old.col2);
  end;



Deepesh Jain
VB,VBA & .NET Specialist
Wiley Support Team

Are you sure you are posting T/SQL - i.e. SQL Server syntax?

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

Thanks for all helps, but it didn't work out well. The trigger doesn't know (the id of the row) which I have updated, deleted or inserted on tlb1 so it can do same thing on tbl2. This is so tricky.
Ex: if I insert, delect or update a certain row with the id 34 in tbl1, the trigger doesnt' know to look for the id 34 in tbl2 to do the same.

The 'inserted' and 'deleted' pseudo tables contain all of the columns in all of the rows being inserted and/or deleted, so all of the data being inserted/updated/deleted is available for the trigger to inspect.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com