Batch Delete

[nkm]

Can we delete rows in batches from a table until all rows with the particular condition are deleted.

e.g.

Delete first 10 from <tab1> where ...

thanks

 

[qyllr]

hello,

try using set rowcount...

set rowcount 10
while exists (select 1
from tableName
where ...)
begin
delete tableName
where ...
end
go

hope this helps,
q.