![]() |
#2
wzh5453946222010-02-09 14:14
|
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的用意是?刚开始写学,不理解。先谢谢了。