请教个简单触发器
A表 ID,NAME,SEX
B表 ID,NAME,FLAG
就是A表在修改或添加时,插入B表
当A表SEX不为NULL,且不为""时 B的FLAG=1
否则为FLAG=0
求完整代码,马上给分
A表 ID,NAME,SEX
B表 ID,NAME,FLAG
就是A表在修改或添加时,插入B表
当A表SEX不为NULL,且不为""时 B的FLAG=1
否则为FLAG=0
求完整代码,马上给分
调试欢乐多
create trigger auto_insert on A表
for insert
as
begin
insert B表 select id,name,flag=case when isnull(SEX,'')='' then 1 else 0 end from inserted
end
A表 ID,NAME,SEX
B表 ID,NAME,FLAG
就是A表在修改或添加时,插入B表
当A表SEX不为NULL,且不为""时 B的FLAG=1
否则为FLAG=0
create trigger ddd on tablea
for update,insert
as
begin
insert into b
select id,name,case when isnull(sex,'') = ''then 0 else 1 end
from inserted
end
for update
as
begin
update b set a.flag=case when isnull(b.SEX,'')='' then 1 else 0 end from B表 a,inserted b where a.id=b.id
end
create or replace trigger A_TRIGGER
before insert on A
referencing new as new_value
for each row
beginif (:new_value.SEX is not null) and (:new_value.SEX<> "") thenupdate B set ID=:new_value.ID , NAME=:new_value.NAME , FLAG=1 where ID==:new_value.IDelseupdate B set ID=:new_value.ID,NAME=:new_value.NAME,FLAG=0 where ID==:new_value.IDend if;