sql-批量删除数据
标签：break from pre color 多少 数据 删除 delete row
sql-批量删除数据
每次删多少
DECLARE @BatchSize INT = 100
WHILE 1 = 1
BEGIN
DELETE TOP (@BatchSize)
FROM tb
WHERE id>30
IF @@ROWCOUNT < @BatchSize
BREAK
END