Insert Trigger: inserted table blank

• yosiasz

  SSCommitted

  Points: 1699

  More actions

  June 5, 2008 at 12:52 pm

  #71430

  Greetings

  When I do an INSERT INTO myTable is the inserted 'virtual' table available only in the scope of the trigger?

  I have three table

  Jobs

  JobID

  Equipment

  EquipmentID

  JobEquipment

  JobEquipmentID

  JobID

  EquipmentID

  When I do an INSERT into Jobs I also pass in a parameter of EquipmentIDs. Now how do I INSERT those into JobEquipment table?

  Thanks

• Jo Pattyn

  SSC-Dedicated

  Points: 32350

  More actions

  June 5, 2008 at 1:31 pm

  #825072

  the tables"inserted" and "deleted" only exist inside the trigger.