create trigger tri_ins
on tb
instead of insert
as
begin
if exists(select 1 from inserted where value=1)
begin
insert tb select 2 from inserted where value=1
end
insert tb select value from inserted where value<>1
end
on tb
instead of insert
as
begin
if exists(select 1 from inserted where value=1)
begin
insert tb select 2 from inserted where value=1
end
insert tb select value from inserted where value<>1
end
为什么不在前台判断呢?