批量update,该怎么解决_Sql Server

批量update
有一张表Inventory (cInvCode ，iSafeNum )
有另一张表bb（cInvCode ，iSafeNum ）

现在我要把表bb里面的iSafeNum 值，批量更新到表Inventory ，条件是
Inventory.cInvCode=bb.cInvCode

谢谢

------解决方案--------------------

SQL code

update aset a.iSafeNum = b.iSafeNumfrom bb a join Inventory b on a.cInvCode = b.cInvCode
------解决方案--------------------
update b
set b.iSafeNum = a.iSafeNum
from bb a join Inventory b on a.cInvCode = b.cInvCode


------解决方案--------------------
SQL codeupdate bset b.iSafeNum = a.iSafeNumfrom bb a join Inventory b on a.cInvCode = b.cInvCode
------解决方案--------------------
SQL codeupdate Inventory set iSafeNum=bb.iSafeNum from Inventory,bb where Inventory.cInvCode=bb.cInvCode