CREATE TRIGGER [dbo].[PPBOMENRTY_ins] ON [dbo].[PPBOMENRTY]
FOR INSERT NOT FOR REPLICATION
AS
SET NOCOUNT ONdeclare @Finterid intselect @Finterid = Finterid from inserted update PPBOMENRTY set FEntrySelfY0270 = b.FHeadSelf0226,FEntrySelfY0270=b.FHeadSelf0227 from PPBOMENRTY a PPBOM b on a.Finterid=b.Finterid where Finterid = @Finterid
SET NOCOUNT OFF
FOR INSERT
NOT FOR REPLICATION
AS
SET NOCOUNT ON; UPDATE a
SET FEntrySelfY0270 = b.FHeadSelf0226 ,
FEntrySelfY0270 = b.FHeadSelf0227
FROM PPBOMENRTY a
INNER JOIN PPBOM b ON a.Finterid = b.Finterid
INNER JOIN inserted i ON a.子表的key=i.子表的key SET NOCOUNT OFF;