比如我写一段,复制到第二段,略微修改,我想高亮查看两段不同之处。
代码: 全选
CREATE TRIGGER Client_T_AU_CityChanged
AFTER UPDATE OF CN_Id ON Client
FOR EACH ROW
WHEN NEW.CN_Id != OLD.CN_Id
BEGIN
UPDATE CityName SET
Ref = Ref-1,
ActionRef = ActionRef - (CASE WHEN OLD.Disable THEN 0 ELSE 1 END)
WHERE Id = OLD.CN_Id;
UPDATE CityName SET
Ref = Ref+1,
ActionRef = ActionRef + (CASE WHEN NEW.Disable THEN 0 ELSE 1 END)
WHERE Id = NEW.CN_Id;
END;
CREATE TRIGGER Client_T_AU_UnitChanged
AFTER UPDATE OF UN_Id ON Client
FOR EACH ROW
WHEN NEW.UN_Id != OLD.UN_Id
BEGIN
UPDATE UnitName SET
Ref = Ref-1,
ActionRef = ActionRef - (CASE WHEN OLD.Disable THEN 0 ELSE 1 END)
WHERE Id = OLD.UN_Id;
UPDATE UnitName SET
Ref = Ref+1,
ActionRef = ActionRef + (CASE WHEN NEW.Disable THEN 0 ELSE 1 END)
WHERE Id = NEW.UN_Id;
END;