CREATE TRIGGER 名1 ON T1
FOR INSERT,DELETE
ASUPDATE T2
SET TotalMoney = TotalMoney - ( a.Price * a.Quality )
FROM INSERTED a
WHERE T2.id=a.id
UPDATE T2
SET TotalMoney = TotalMoney + ( a.Price * a.Quality )
FROM DELETED a
WHERE T2.id=a.idgo
FOR INSERT,DELETE
ASUPDATE T2
SET TotalMoney = TotalMoney - ( a.Price * a.Quality )
FROM INSERTED a
WHERE T2.id=a.id
UPDATE T2
SET TotalMoney = TotalMoney + ( a.Price * a.Quality )
FROM DELETED a
WHERE T2.id=a.idgo
FOR INSERT
AS
UPDATE T2
SET TotalMoney = TotalMoney - ( a.Price * a.Quality )
FROM INSERTED a
WHERE T2.id=a.idCREATE TRIGGER t_t1d ON T1
FOR DELETE
AS
UPDATE T2
SET TotalMoney = TotalMoney + ( a.Price * a.Quality )
FROM DELETED a
WHERE T2.id=a.id
FOR INSERT,DELETE,update
ASUPDATE T2
SET TotalMoney = TotalMoney - ( a.Price * a.Quality )
FROM INSERTED a
WHERE T2.id=a.id
UPDATE T2
SET TotalMoney = TotalMoney + ( a.Price * a.Quality )
FROM DELETED a
WHERE T2.id=a.idgo