UPDATE Shop_Product_Base
SET StockCode = b.StockCode
from Shop_Product_Base as a,View_1 as b
WHERE a.ShopId = b.ShopId
嵌套更新多条sql语句
最新推荐文章于 2022-05-06 18:03:44 发布
UPDATE Shop_Product_Base
SET StockCode = b.StockCode
from Shop_Product_Base as a,View_1 as b
WHERE a.ShopId = b.ShopId