Wikis > SQL Wiki > DELETE BULK

WHILE @@ROWCOUNT <> 0
BEGIN
   DELETE TOP (1000000) FROM [database].[schema].[table] WHERE [Col1] = 'abc'
   DBCC SHRINKDATABASE(N'_APPL' )
END

Category: Tags: