Create Trigger ?

• andreask

  Mr or Mrs. 500

  Points: 542

  More actions

  January 4, 2005 at 12:43 pm

  #60905

  Dear All,

  I am trying to create a trigger using the following scenario:

  Table A:

  Field A1, Field A2, Field A3, Field A4

  Table B:

  Field B1, Field B2, Field B3

  On Update (ONLY) of Field A1 I need to insert a record in Table B using values from the updated record in Table A.

  Please help.  This is my first trigger and the help in BOL did not really help me.

  Thanks & Regards,

  Andreas

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  January 4, 2005 at 12:52 pm

  #535844

  CREATE TRIGGER [trTableA_Update] ON [dbo].[tableA]

  FOR UPDATE

  AS

  SET NOCOUNT ON

  If Update (ColName_That_Causes_Audit)

  begin

  Insert into TableB (Field1, Field2...) Select Field1, Field2... from Inserted

  end