declare @onecount int
set @onecount=100000
print getdate()
while 1=1
begin
delete top(@onecount) from 表名 where CreatedOn<'2020-09-21' ;
--不要写任何的print,否则会出现卡顿
IF (@@rowcount<@onecount) BREAK;
end
declare @onecount int
set @onecount=100000
print getdate()
while 1=1
begin
delete top(@onecount) from 表名 where CreatedOn<'2020-09-21' ;
--不要写任何的print,否则会出现卡顿
IF (@@rowcount<@onecount) BREAK;
end