ALTER TRIGGER ggscddmxb_update
ON mom_orderdetail --生产订单明细资料
FOR INSERT
AS
DECLARE @MoDId INT,
@OrderCode NVARCHAR(30),
@SoCode NVARCHAR(30)
SELECT @MoDId=MoDId FROM Inserted;
SELECT @OrderCode=MoCode FROM v_mom_orderdetail
SELECT @SoCode=MoCode FROM v_mom_orderdetail
WHERE MoDId=@MoDId;
UPDATE mom_orderdetail SET OrderCode=@SoCode,SoCode=@SoCode
WHERE MoDId=@MoDId