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
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
ASKED:
May 19, 2010 7:03 AM GMT
UPDATED:
May 19, 2010 2:28:19 PM GMT
RELATED QUESTIONS
- Trigger over table that uses transaction inserts
- trigger to update
- insert and updat remote table
- Table Level Triggers - Triggers on Two Fields Within the Same Table
- Doubt regarding EXCEPTIONS
- Subscript beyond count on nested table (trying to update a column in a trigger for the same table as trigger)
- Creating Database Trigger
- How to create a trigger for updating a table for a quantity decrease?
- Oracle coding error ORA-06550
- procedure create with compilation error ora-6550
5 pts.
