suhua的博客

批量更新sql |批量update sql  SELECT g.GoodsID,g.StockNum,a.GoodsID,a.Amount FROM Goods g INNER JOIN (SELECT GoodsID,SUM(Amount) AS Amount FROM OrderGoods WHERE OrderID IN(SELECT OrderID FROM [Order] W

直接上图一、选择数据库二、三、四、五、六、