CREATE TRIGGER tr_hj2_grjj ON hj2_grjj FOR INSERT, UPDATE AS IF @@ROWCOUNT = 0 RETURN EXEC sp_configure 'nested triggers', 0 以下是觸發器主體代碼 --UPDATE hj2_grjj SET --gxdj=x.gxdj, --jjje=x.gxdj*g.scsl, --djje=CASE WHEN ISNULL(g.zgbh1,'')= '' THEN 0 ELSE x.gxdj*g.scsl*0.70 END --FROM (inserted i JOIN hj2_grjj g ON i.__sno=g.__sno) --LEFT JOIN hj2_scdd s ON g.ddbh=s.ddbh --LEFT JOIN hj2_xtgx x ON s.xtbh=x.xtbh AND g.gxbh=x.gxbh EXEC sp_configure 'nested triggers', 1
CREATE TRIGGER tr_hj2_grjj ON hj2_grjj FOR INSERT, UPDATE
AS
IF @@ROWCOUNT = 0 RETURN
EXEC sp_configure 'nested triggers', 0
以下是觸發器主體代碼
--UPDATE hj2_grjj SET
--gxdj=x.gxdj,
--jjje=x.gxdj*g.scsl,
--djje=CASE WHEN ISNULL(g.zgbh1,'')= '' THEN 0 ELSE x.gxdj*g.scsl*0.70 END
--FROM (inserted i JOIN hj2_grjj g ON i.__sno=g.__sno)
--LEFT JOIN hj2_scdd s ON g.ddbh=s.ddbh
--LEFT JOIN hj2_xtgx x ON s.xtbh=x.xtbh AND g.gxbh=x.gxbh
EXEC sp_configure 'nested triggers', 1