Writing a Single Trigger on Two Relations

• shohelr2003

  Hall of Fame

  Points: 3535

  More actions

  December 30, 2012 at 4:07 am

  #393857

  Dear,

  I have an application running on my system. There is a certain module that if I click on 'Save' button, it inserts a row on Header & Detail tables. Now I want to write a single trigger on Header & Detail tables which will insert a row into 'Test' table.

  How can I do this? Please help me.

  Regards,

  Akbar

• Eklavu

  Right there with Babe

  Points: 790

  More actions

  December 30, 2012 at 6:26 am

  #1572393

  if you want to insert the data from the two tables (header and detail) to test table you can do something like this...

  1. get the inserted value in dbo.inserted

  2. join dbo.inserted and Header Table.

  sample code below

  CREATE TRIGGER Detail_Insert

  ON detail

  FOR INSERT

  AS

  insert into Detail_table

  select I.id, * from dbo.inserted I

  inner join header H

  on I.id = H.Id

  This code will work. Just make some neccessary adjustment as to what fields to you want