DELETE BULK PageHistoryWikis > SQL Wiki > DELETE BULK WHILE @@ROWCOUNT <> 0 BEGIN DELETE TOP (1000000) FROM [database].[schema].[table] WHERE [Col1] = 'abc' DBCC SHRINKDATABASE(N'_APPL' ) END Category: SQLT-SQL Tags: SQL T-SQL Von Frank Uray|2015-06-15T22:00:56+02:00Juni 15th, 2015|Kommentare deaktiviert für DELETE BULK Share This Story, Choose Your Platform! FacebookTwitterRedditLinkedInTumblrPinterestVkE-Mail Über den Autor: Frank Uray