CREATE TRIGGER Trigger_PURTB
ON PURTB
AFTER INSERT,UPDATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for trigger here
IF EXISTS(SELECT TOP 1 FROM INSERTER WHERE TB032='Y')
BEGIN
UPDATE PURTB SET TB011=B.TA013+3
FROM INSERTER A
LEFT JOIN PURTA B
WHERE A.TA001=B.TB001 AND A.TA002=B.TB002 AND A.TB032='Y'
END
END
GO
create trigger tr_PURTB
on PURTB for insert,update as
IF EXISTS(SELECT 1 FROM Inserted WHERE 急料='Y')
BEGIN
UPDATE b SET b.TB011=a.MB013+3
FROM PURTB b,PURTA a
WHERE a.TA001=b.TB001
AND a.TA002=b.TB002
AND b.急料='Y'
AND EXISTS(SELECT 1 FROM Inserted WHERE Inserted.TB001=b.TB001 AND Inserted.TB002=b.TB002)
END
差不多就是这个样子