delete with no index? 1

[Yerdon]

Hi,

How can I delete a certain number of rows from a table with no key field? Something like:

DELETE TOP 292166 FROM TABLENAME

This is a table I just imported into and I need to delete the first few hundred thousand rows and leave the rest.

Any ideas?

Thanks!

Joseph

 

[cfStarlight]

One way is to use ROWCOUNT . Don't forget to reset the ROWCOUNT back to zero when finished

SET ROWCOUNT 292166
delete from theTable
SET ROWCOUNT 0

 

[Yerdon]

This rocks! Thank you!