update corpworker set balance = balance +A.costmoney from corpworder, (select costmoney,workerID from deleted) as A where corpworder.workerID = A.workerID
update corpworker set balance = balance + deleted.costmoney from corpworder, deleted where corpworder.workerID = deleted.workerID
SQL SERVER里的触发器不是单行的,所以你要改成这样: update corpworker set balance = balance + (select sum(costmoney) from deleted) where workerID in (select workerID from deleted );TO progame(呵呵呵(傻笑中): 你的写法好像和原来的没有任何不同啊?
刚才写的错了, 应该这样:update corpworker x set balance = balance + (select sum(costmoney) from deleted where workID = x.workID) where workerID in (select workerID from deleted where workID = x.workID);
哈哈,还是有问题, 不好意思:update corpworker x set balance = balance + (select sum(costmoney) from deleted where workerID = x.workerID) where workerID in (select distinct workerID from deleted);
set balance = balance + deleted.costmoney
from corpworder, deleted
where corpworder.workerID = deleted.workerID
update corpworker
set balance = balance + (select sum(costmoney) from deleted)
where workerID in (select workerID from deleted );TO progame(呵呵呵(傻笑中): 你的写法好像和原来的没有任何不同啊?
set balance = balance + (select sum(costmoney) from deleted where workID = x.workID)
where workerID in (select workerID
from deleted
where workID = x.workID);
set balance = balance + (select sum(costmoney) from deleted where workerID = x.workerID)
where workerID in (select distinct workerID
from deleted);