CREATE trigger test_insert on dbo.test after INSERT as begin if exists(select * from inserted where TA002 not in(select ta002 from test)) rollback end
CREATE trigger test_insert on dbo.test after INSERT as begin if not exists (select 1 from test where TA002 = (select TA002 from inserted)) begin ROLLBACK transaction Print ('输入出错了,请重新输入') end end不过看你的需求,需要对test的ta0002列建立个外键表
我的要求触发器判断两个字段值TA002和TA003,当(TA002='003' and TA002='004') and TA003='N'不可以向表中写入数据返回错误信息,
on dbo.test
after INSERT
as
begin
if exists(select * from inserted where TA002 not in(select ta002 from test))
rollback
end
as
begin
if not exists (select 1 from test where TA002 = (select TA002 from inserted))
begin
ROLLBACK transaction
Print ('输入出错了,请重新输入')
end
end不过看你的需求,需要对test的ta0002列建立个外键表