删除数据问题，急

[msrnt]

怎样删除数据库里的数据只保留最新的100条？谢谢

[msrnt]

数据一直在自动增加中的，只保留最新的100条。

[hookee]

insert into table(...) values(...)
delete from table where id not in (select top (100) id from table order by id desc)

[zzhqiao]

创建触发器
create trigger t_delete on tablename
for insert
as begin
delete from tablename where id not in( select top 100 id from tablename order by 时间字段)
end

[zzhqiao]

create trigger t_delete on tablename
for insert
as begin
delete from tablename where id not in( select top 100 id from tablename order by id desc)
end

[liuwei_IT_love]

顶一下二楼，学习

[99percent]

delete from table where id not in (select top (100) id from table order by id desc)

其实这条已经行了。