trigger to update 2nd table

• ksexton

  SSCrazy

  Points: 2790

  More actions

  May 2, 2002 at 11:46 am

  #58161

  I need to write a trigger to update the identity column in the 2nd table if a new row is added to the first table's identity column.

  Here's what I have (doesn't work)

  create table x (col1 numeric)

  create table z (col1 numeric)

  CREATE TRIGGER trigger_name

  ON x

  FOR INSERT, UPDATE

  AS

  If UPDATE(col1)

  BEGIN

  update z set col1= x.col1 from x

  END

  GO

  insert into x values (6)

• Antares686

  SSC Guru

  Points: 125444

  More actions

  May 2, 2002 at 12:50 pm

  #428359

  Duplicate post, see reponses in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=3982&FORUM_ID=5&CAT_ID=1&Topic_Title=trigger+to+update+2nd+table&Forum_Title=Administration

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)