SQL Server Performance Forum – Threads Archive
Is there any way to delete a select number of rows. I don’t want to delete a whole table, but rather a 1000 or so at a time. Is there a way to do this? Thanks,
Check SET ROWCOUNT in BOL may be help. Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
… to elaborate Luis’s tip :
SET ROWCOUNT 1000
delete from table where (condition)
SET ROWCOUNT 0 _________