Firing Trigger

• reddy_prathap

  Valued Member

  Points: 53

  More actions

  December 19, 2003 at 6:14 am

  #83729

  hi,

  i am writing a trigger

  CREATE TRIGGER Ztrig

  ON TZ

  FOR INSERT AS

  BEGIN

  INSERT TY VALUES ('')

  END

  then the values are inserted into TY first or TZ first , in other words to which table values will insert first

  CREATE TRIGGER Ztrig

  ON TZ

  AFTER INSERT AS

  BEGIN

  INSERT TY VALUES ('')

  END

  if we use AFTER Instead of FOR then to which table values will insert first

  Thanks,

  Pratap

• Jonathan

  SSC-Insane

  Points: 20427

  More actions

  December 19, 2003 at 6:33 am

  #487196

  AFTER is the default behavior, so both your triggers are equivalent.

  --Jonathan

  
  
  --Jonathan