27,579
社区成员
发帖
与我相关
我的任务
分享
USE AdventureWorks;
GO
UPDATE Sales.SalesPerson
SET SalesYTD = SalesYTD + SubTotal
FROM Sales.SalesPerson AS sp
JOIN Sales.SalesOrderHeader AS so
ON sp.SalesPersonID = so.SalesPersonID
AND so.OrderDate = (SELECT MAX(OrderDate)
FROM Sales.SalesOrderHeader
WHERE SalesPersonID =
sp.SalesPersonID);
GO
update a set a.amount=a.amount+b.changeamount
output deleted.*,inserted.* --此处输出更新前后的值,可知更改了多少
from #a a
inner join #b b on a.mebid=b.mebid