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