UPDATE A
set A.[AddressNo]=B.[AddressNo]
from [dbo].[Log_Ammeter] A
left join [dbo].[ComAmmeter] B on A.[AmmeterID]=B.ID
UPDATE A
SET A.[ReadNumber]=B.[ReadNumber],
A.[Status]=B.[Status],
A.[Copyist]=B.[Copyist]
FROM [Log_Ammeter_Bak] A,[Log_Ammeter_Bak] B
where A.[AddressNo]=B.[AddressNo] and A.[ReadTime]=B.[ReadTime]
本站仅提供存储服务,所有内容均由用户发布,如发现有害或侵权内容,请
点击举报。