SQLServer分批删除

DECLARE @BatchSize_CS INT
        SET @BatchSize_CS = 10000 -- 设置每批删除的记录数量

        WHILE 1 = 1
        BEGIN
            DELETE TOP (@BatchSize_CS) FROM dbo.Stock_CS
            WHERE ID IN (SELECT TOP (@BatchSize_CS) ID FROM dbo.Stock_CS c
            WHERE c.Factory = @Factory)
            IF @@ROWCOUNT < @BatchSize_CS
                BREAK
        END

 

参阅：https://www.cnblogs.com/jiaxuekai/p/18189664