34,588
社区成员
发帖
与我相关
我的任务
分享
create trigger ta
on a
for insert
as
insert into b(id,type)
select i.id,(case when i.type = 'check' then '是' else '否' end ) from inserted as i
go
create trigger tri_a_insert
on a
for insert
as
begin
insert b
select id,case when type='check' then '是' else type end
from inserted
end
insert into b values (inserted.id,(case when inserted.type = 'check' then '是' when inserted.type = 'uncheck' then '否' else '否' end))
insert into b values (inserted.id,(case when inserted.type = 'check' then '是' else '否' end))