SQL Server Performance Forum – Threads Archive

delete rows

Hi,
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,
Ben

---

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.
Bertrand Russell

---

… to elaborate Luis’s tip :
SET ROWCOUNT 1000
delete from table where (condition)
SET ROWCOUNT 0 _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

---

]]>