SQL

Delete删除思路1 适用于表中有大量数据，用Delete语句删除时慢的处理思路 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 DECLARE @DeleteRows INT DECLARE @DeleteFlag INT = 1 WHILE @DeleteFlag > 0 BEGIN BEGIN TRANSACTION DELETE TOP (5000) orm FROM dbo.C_OrderRawMaterial orm INNER JOIN dbo.C_Order od ON orm.OrderId = od.Id WHERE od.OrderStatus IN(200, 300) AND orm.OrderId IN ( SELECT Id FROM dbo.C_Order o WHERE o.OrderStatus IN(200, 300) --AND orm....