SQL SERVER 2000 夸表更新 UPDATE
表1
AutoID,iUnitCost,iPrice
表2
AutoID,iUnitCost,iPrice表1.AutoID=表2.AutoID 将 set 表1.iUnitCost=表2.iUnitCost,表1.iPrice=表2.iPrice
ACCESS 下可执行但 SQL SERVER却不行:
UPDATE 表1 INNER JOIN 表2 ON 表1.AutoID = 表2.AutoID SET 表1.iUnitCost = [表2].[iUnitCost], 表1.iPrice = [表2].[iPrice]
表1
AutoID,iUnitCost,iPrice
表2
AutoID,iUnitCost,iPrice表1.AutoID=表2.AutoID 将 set 表1.iUnitCost=表2.iUnitCost,表1.iPrice=表2.iPrice
ACCESS 下可执行但 SQL SERVER却不行:
UPDATE 表1 INNER JOIN 表2 ON 表1.AutoID = 表2.AutoID SET 表1.iUnitCost = [表2].[iUnitCost], 表1.iPrice = [表2].[iPrice]
表1.iUnitCost = [表2].[iUnitCost], 表1.iPrice = [表2].[iPrice]
FROM 表1
INNER JOIN 表2 ON 表1.AutoID = 表2.AutoID
表1.iUnitCost = [表2].[iUnitCost], 表1.iPrice = [表2].[iPrice]
FROM 表1
WHERE 表1.AutoID = 表2.AutoID
SQL 直接支持这样的更新.
UPDATE 表1 SET
表1.iUnitCost = [表2].[iUnitCost], 表1.iPrice = [表2].[iPrice]
FROM 表2 --手误,修改.
WHERE 表1.AutoID = 表2.AutoID
from 表1 INNER JOIN 表2 ON 表1.AutoID = 表2.AutoID