create trigger tr_abc_up
on t_abc
for update
as
update t_abc set c = '1' from t_abc join inserted
on t_abc.a = inserted.a and t_abc.b = inserted.b
return
on t_abc
for update
as
update t_abc set c = '1' from t_abc join inserted
on t_abc.a = inserted.a and t_abc.b = inserted.b
return
on t_abc
for update
as
if @@rowcount=0
return
else
update t_abc set c = '1' from t_abc join inserted
on t_abc.a = inserted.a and t_abc.b = inserted.b
return