SA Developer .NET

Is it possible to DELETE a TOP specified number of records from a table?

eg. DELETE TOP 100 * FROM tb_MyTable

The Objective is to generically batch DELETE's so that it is not dependant on a WHERE clause.

 

---

A Program is only Complete when the Programmer Dies

Yes, in SQL 2005 and above. You're missing brackets though

DELETE TOP (100) FROM MyTable 

---

Gail Shaw - SQL In the Wild
SQL Server MVP
--
Chaos, panic and disorder. My job here is done!

Wouldn't the following also work?

SET ROWCOUNT 100
DELETE FROM MyTable;

 

---

Microsoft Xbox MVP | http://craign.net/

It will. You may want to note though that ROWCOUNT is deprecated for use with data modification statements in SQL 2008.

---

Gail Shaw - SQL In the Wild
SQL Server MVP
--
Chaos, panic and disorder. My job here is done!

Awesome; both works :)

Thank You.

I guess I can scrap this idea :)

delete tb_BulkDelete

join (select top 100 * from tb_BulkDelete) tbd on

bd.BulkDeleteID = tbd.BulkDeleteID

---

A Program is only Complete when the Programmer Dies