22,209
社区成员
发帖
与我相关
我的任务
分享
create trigger trigger_name on tablename
for update
as
begin
if((select c1 from inserted)='a' and (select c2 from inserted)=0)
update tablename set c2=1
end
--try
create trigger tri_name on t1
for update
as
update t1
set c2=1
from inserted i,t1
where i.id=t.id and i.c1='a' and i.c2=0