help me create trigger update column
CREATE TRIGGER Trigger_UPDATE_BIENLAI_TIENNOP ON BIENLAI
FOR UPDATE,INSERT,DELETE
AS
IF (@@ROWCOUNT = 0)
BEGIN
PRINT ' TABLE is null'
RETURN
END
IF UPDATE(TIENNOP)
BEGIN UPDATE BL1 SET BL1.TIENNOP = BL3.TIENNOP
FROM BIENLAI BL1,DELETED BL2,INSERTED BL3
WHERE BL1.SOBL = BL2.SOBL AND (BL3.TIENNOP < 300000)
PRINT ' finish update '
END
/* trigger not check ' BL3.TIENNOP < 300000' when me perforemence 'Update' data ' >300000' helpme slove this problem*/
thanks
Software/Hardware used:
FOR UPDATE,INSERT,DELETE
AS
IF (@@ROWCOUNT = 0)
BEGIN
PRINT ' TABLE is null'
RETURN
END
IF UPDATE(TIENNOP)
BEGIN UPDATE BL1 SET BL1.TIENNOP = BL3.TIENNOP
FROM BIENLAI BL1,DELETED BL2,INSERTED BL3
WHERE BL1.SOBL = BL2.SOBL AND (BL3.TIENNOP < 300000)
PRINT ' finish update '
END
/* trigger not check ' BL3.TIENNOP < 300000' when me perforemence 'Update' data ' >300000' helpme slove this problem*/
thanks
Software/Hardware used:
ASKED:
May 19, 2010 7:03 AM
UPDATED:
May 19, 2010 2:28 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
