--每次删多少 DECLARE @BatchSize INT = 100 WHILE 1 = 1 BEGIN DELETE TOP (@BatchSize) FROM tb WHERE id>30 IF @@ROWCOUNT < @BatchSize BREAK END
sql-批量删除数据
原文：https://www.cnblogs.com/JinweiChang/p/13396556.html
