34,590
社区成员
发帖
与我相关
我的任务
分享
update Inventory set iSafeNum=bb.iSafeNum
from Inventory,bb
where Inventory.cInvCode=bb.cInvCode
update b
set b.iSafeNum = a.iSafeNum
from bb a join Inventory b on a.cInvCode = b.cInvCode
update a
set a.iSafeNum = b.iSafeNum
from bb a join Inventory b on a.cInvCode = b.cInvCode