Viewing post 1 (of 1 total)
This would also work:
SET ROWCOUNT 2000 -- this will limit the number of rows in the delete
DECLARE @Rowcount int
SET @Rowcount = -1 -- Initialise
WHILE @Rowcount <> 0
BEGIN
...
March 6, 2013 at 8:51 am
#1594020