create trigger kk on tb after insert as begin if(select [type] from inserted )=0 update tb set x_id=id from inserted where inserted.x_id=x_id and [type]=o end
declare @type int,@x_id int set @type=1 --你想插入的type值 set @x_id=1--你想插入的x_id值 if(@type=1) begin insert tb values(@type,@x_id) end else begin insert tb values(@type,(select MAX(id)+1 from tb)) end
on tb after insert
as
begin
if(select [type] from inserted )=0
update tb
set x_id=id
from inserted
where inserted.x_id=x_id and [type]=o
end
我看一个朋友用Access 也做成了 当然我是用Mssql
不过要知道ACCESS是没有触发器....那要怎么实现?和触发器比哪个快呢
你用约束吧
declare @type int,@x_id int
set @type=1 --你想插入的type值
set @x_id=1--你想插入的x_id值
if(@type=1)
begin
insert tb
values(@type,@x_id)
end
else
begin
insert tb
values(@type,(select MAX(id)+1 from tb))
end