SET Latitude=[dbo].[Project_HydropowerStationProject].Latitude, Longitude=[dbo].[Project_HydropowerStationProject].Longitude
from [dbo].[Project_HydropowerStationProject]
WHERE [dbo].[Plan_WaterStation].[Name]=
[dbo].[Project_HydropowerStationProject].[HydropowerStationName]
update A SET 字段1=B表字段表达式, 字段2=B表字段表达式 from B WHERE 逻辑表达式
from [dbo].[Project_HydropowerStationProject]
WHERE [dbo].[Plan_WaterStation].[Name]=
[dbo].[Project_HydropowerStationProject].[HydropowerStationName]
update A SET 字段1=B表字段表达式, 字段2=B表字段表达式 from B WHERE 逻辑表达式