Bulk DELETE on SQL Server 2008 (Is there anything like Bulk Copy (bcp) for delete data?) -
Is there a solution for bulk delete in SQL Server?
I can not use TRUNCATE because I
is there anything like Bulk Copy (BCP) to delete data?
no.
You want DELETE with a WHERE segment: it's standard SQL.
What you can do is remove the batch like this:
select 'start' --sets @@ ROWCOUNT WHILE @@ ROWCOUNT & lt; & Gt; 0 Remove Top (xxx) Matables where ...
Or if you want to remove a very high percentage of rows ...
SELECT col1 , # Holdingbat from Maitable in Call 2, .... Main condition .. Select the Transaction Table Methyl Intest Miteable (Call 1, Cola 2, ...), call 1, Cola 2, ... #holdingtable
Comments
Post a Comment