WHILE EXISTS ( SELECT * FROM table WHERE <condition to delete>)
BEGIN
SET ROWCOUNT 1000
DELETE Table WHERE <Condition>
SET ROWCOUNT 0
ENd
Site Stats
follow:- RSS
WHILE EXISTS ( SELECT * FROM table WHERE <condition to delete>)
BEGIN
SET ROWCOUNT 1000
DELETE Table WHERE <Condition>
SET ROWCOUNT 0
ENd
follow: RSS