update GOODSDOC set GoodsCode = b.goodscode from #b b where goodsdoc.GoodsId = b.GoodsId 把#b 更新到 goodsdoc中 ,