Trigger to update two tables

• deemo

  SSC Veteran

  Points: 297

  More actions

  September 29, 2003 at 10:19 pm

  #83216

  Please help me on creating a trigger that will insert value in two tables.

  this is what i have , 2 tables (Invoice Summary,Invoice Details) and an Order tables, I need to create an insert trigger on the order table that will insert value in both Invoice summary and Invoice Details.

  Thanks and best regards,,,

• ray_higdon

  SSCarpal Tunnel

  Points: 4589

  More actions

  September 30, 2003 at 3:20 am

  #476322

  Without knowing the DDL this is just a guess:

   create trigger blah on table 
  
  for update, insert, delete
  
  as
  
  insert into table1 select * from inserted
  
  insert into table2 select * from inserted

  This is probably not what you need but without more information...Post more info if this does not help.

  Ray Higdon MCSE, MCDBA, CCNA

  ------------
  
  Ray Higdon MCSE, MCDBA, CCNA