trigger script

• AJ-92543

  SSC Eights!

  Points: 852

  More actions

  September 25, 2003 at 10:49 am

  #160777

  I'm developing in MS SQL Server 7.0 environment.

  This is the script for the trigger:

  CREATE TRIGGER trgtblBag_data ON tblDelete_Inventory

  FOR DELETE

  AS

  Declare @work_ord_num char;

  SELECT @work_ord_num = work_ord_num

  FROM tblDelete_Inventory

  DELETE tblBag_data

  WHERE @work_ord_num = work_ord_num

  Thanks!

• gljjr

  SSChampion

  Points: 10080

  More actions

  September 25, 2003 at 5:37 pm

  #475899

  I think what you really want is to query the "deleted" table rather than the actual table.

  IE:

  
  
  CREATE TRIGGER trgtblBag_data ON tblDelete_Inventory
  
  FOR DELETE
  
  AS
  
  
  
  DELETE t
  
  FROM tblBag_Data BD
  
      JOIN deleted d ON BD.work_ord_num = d.work_ord_num
  
  
  
  RETURN
  
  
  
  

  Gary Johnson

  Microsoft Natural Language Group

  DBA, Sr. DB Engineer

  
  
  
  Gary Johnson
  Microsoft Natural Language Group
  DBA, Sr. DB Engineer

  This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.