--例子:删除第10条记录--借助临时表--查询select top 10 * into #tp from 表名set rowcount 9delete #tpset rowcount 0select * from #tpdrop table #tp --删除select top 10 * into #tp from 表名set rowcount 10delete 表名set rowcount 9insert into 表名 select * from #tpdrop table #tp
alter table table_Name add ident int identity(1,1) not null delete from table_Name where ident=4 alter table table_Name drop column ident
今天看到一个有意义的命令 我尝试补充一下: set rowcount n-1 delete top 1 from table1 不知是否满足你的需求
--删除select top 10 * into #tp from 表名set rowcount 10delete 表名set rowcount 9insert into 表名 select * from #tpdrop table #tp
delete from table_Name where ident=4
alter table table_Name drop column ident
我尝试补充一下:
set rowcount n-1
delete top 1 from table1
不知是否满足你的需求