前2000行?需要有一个排序标准,如果没有就可以按照表的默认排序标准,具体SQL语句如下:delete from 表名 where id in(select top 2000 id from tablename order by 排序标准字段) 呵呵,试一下,应该没有问题,^_^
delete top 2000 from Table
DELETE TABLENAME WHERE ID IN(SELECT TOP 2000 ID FROM TABLENAME)