Bulk DELETE on SQL Server 2008 (Is there anything like Bulk Copy (bcp) for delete data?)

by

No.

You want a DELETE with a WHERE clause: this is standard SQL.

What you can do is batch deletes like this:

SELECT 'Starting' --sets @@ROWCOUNT
WHILE @@ROWCOUNT <> 0
    DELETE TOP (xxx) MyTable WHERE ...

Or if you want to remove a very high percentage of rows…

SELECT col1, col2, ... INTO #Holdingtable
           FROM MyTable WHERE ..opposite condition..
TRUNCATE TABLE MyTable
INSERT MyTable (col1, col2, ...)
           SELECT col1, col2, ... FROM #Holdingtable

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. Is it possible to write single query on two table which are not connected to each other?
  3. CROSS JOIN vs INNER JOIN in SQL
  4. Can I Comma Delimit Multiple Rows Into One Column? [duplicate]
  5. SET versus SELECT when assigning variables?
  6. Multiple INSERT statements vs. single INSERT with multiple VALUES
  7. Split function equivalent in T-SQL?
  8. Is the NOLOCK (Sql Server hint) bad practice?
  9. Generate Dates between date ranges
  10. Is having an ‘OR’ in an INNER JOIN condition a bad idea?
  11. How to print VARCHAR(MAX) using Print Statement?
  12. Where value in column containing comma delimited values
  13. Parse comma-separated string to make IN List of strings in the Where clause
  14. SQL query to split column data into rows
  15. Common Table Expression, why semicolon?
  16. T-SQL split string based on delimiter
  17. Concatenate values based on ID
  18. Splitting delimited values in a SQL column into multiple rows
  19. SQL “between” not inclusive
  20. Can I set ignore_dup_key on for a primary key?
  21. Using PIVOT in SQL Server 2008
  22. Stored procedure that exports data into csv files only exports to one file
  23. How do I prevent a database trigger from recursing?
  24. TSQL – How to use GO inside of a BEGIN .. END block?
  25. How to combine results of two queries into a single dataset
  26. When using GETDATE() in many places, is it better to use a variable?
  27. Executing SQL Server Agent Job from a stored procedure and returning job result
  28. SQL take just the numeric values from a varchar
  29. Cumulative Total in MS Sql server [duplicate]
  30. COALESCE Function in TSQL

Leave a Comment