举个例子~
UPDATE e SET e.money = e.money + d.amount FROM employee e INNER JOIN (SELECT empid,amount=sum(amount) FROM deleted WHERE rechargeable=1 GROUP BY empid) d ON d.empid=e.id
icycore 2014-02-27 15:17 原文
举个例子~
UPDATE e SET e.money = e.money + d.amount FROM employee e INNER JOIN (SELECT empid,amount=sum(amount) FROM deleted WHERE rechargeable=1 GROUP BY empid) d ON d.empid=e.id