Trigger COPTD.TD054
跳至導覽
跳至搜尋
MOCTA TO LSDTEST.dbo.TATOCOPTD
<sql> CREATE TRIGGER TATOCOPTD ON MOCTA AFTER INSERT AS BEGIN INSERT INTO LSDTEST.dbo.TATOCOPTD (TD01,TD02,TD03,TD54) SELECT TA026,TA027,TA028,TA002 FROM MOCTA LEFT JOIN LSDTEST.dbo.TATOCOPTD ON TA026=TD01 AND TA027=TD02 AND TA028=TD03 WHERE MOCTA.CREATE_DATE=convert(char,getdate(),112) AND TD01 IS NULL END </sql>