/*SQL2000快速批量删除前N条数据--前提:只能根据拥有聚集索引的id才能达到准确无误的删除操作--下面是一个简单的例子--废话不多说,看代码 */if object_id('tb') is not null drop table tbgocreate table tb (id int)goinsert tb select 2union all select 1union all select 3gocreate index idx1 on tb(id)goset rowcount 2delete a from tb a with(index = idx1)set rowcount 0goselect * from tbgodrop table tbgo