限制表的記錄數

[wangyangcheng]

可否做到使一個表里面能容納的最大記錄數為一固定數﹐如30條﹐并且超過30條之后再插入的話則它會自動把最前面的記錄刪除掉?
謝謝﹗

[haozhiyuan2003]

CREATE TRIGGER yourname ON goods
instead of INSERT
AS
if (select count(*) from goods)<30
begin
insert into goods select * from inserted
end

[pengdali]

CREATE TRIGGER 名1 ON 表
FOR INSERT
AS
if (select sum(1) from goods)>50
rollback tran

[pengdali]

CREATE TRIGGER 名1 ON 表
FOR INSERT
AS
if (select sum(1) from goods)>50
rollback tran

[pengdali]

CREATE TRIGGER 名1 ON 表
FOR INSERT
AS
if (select sum(1) from goods)>50
rollback tran

[suowei14]

dgs

[pengdali]

CREATE TRIGGER 名1 ON 表
FOR INSERT
AS
if (select sum(1) from goods)>30
rollback tran

[wangyangcheng]

Thanks for everybody﹗

[zjcxc]

create trigger t_aa on 表名
for insert
as
if(select count(*) from 表名)>30 rollback tran

[sdhdy]

create trigger trig_aa_insert on aa
for insert
as
if(select count(*) from aa)>30
delete aa where ...最前面那条记录的条件

[maoyesky]

alter trigger trigger_sky_test
on aa
for insert
as
if ((select sum(1) from aa) > 11 )
delete aa where 主健 =(select top 1 主健 from aa)

[erigido]

create trigger t_aa on 表名
for insert
as
if(select count(*) from 表名)>30 rollback tran

[txlicenhe]

用触发器:

[angelior]

create trigger t_aa on 表名
for insert
as
begin
if(select count(*) from 表名)>30
delete from 表名 where 刪除的條件
end