方法一
SET ROWCOUNT 500
delete_more:
DELETE FROM LogMessages WHERE LogDate < '2/1/2002'
IF @@ROWCOUNT > 0 GOTO delete_more
SET ROWCOUNT 0
方法二
while 1=1
begin
delete top 500 from table
end
if @@ROWCOUNT <500 break;
方法一
SET ROWCOUNT 500
delete_more:
DELETE FROM LogMessages WHERE LogDate < '2/1/2002'
IF @@ROWCOUNT > 0 GOTO delete_more
SET ROWCOUNT 0
方法二
while 1=1
begin
delete top 500 from table
end
if @@ROWCOUNT <500 break;