create trigger tu_tbaa on tbaa for update as begin if update(a) begin update TABB set a = i.a from inserted i,deleted d where i.主键 = d.主键 and i.a <> d.a and i.关联字段= TABB.关联字段 end end
create trigger tu_tbaa on tbaa for update as begin if update(a) begin update TABB set a = i.a from inserted i,deleted d where i.主键 = d.主键 and i.a <> d.a and i.关联字段= TABB.关联字段 end end
create trigger tu_tbaa on tbaa for update as begin if update(a) begin update TABB set a = i.a from inserted i,deleted d where i.主键 = d.主键 and i.a <> d.a and i.关联字段= TABB.关联字段 end end
for update
as
begin
if update(a)
begin
update TABB
set a = i.a
from inserted i,deleted d
where i.主键 = d.主键
and i.a <> d.a
and i.关联字段= TABB.关联字段
end
end
for update
as
begin
if update(a)
begin
update TABB
set a = i.a
from inserted i,deleted d
where i.主键 = d.主键
and i.a <> d.a
and i.关联字段= TABB.关联字段
end
end
for update
as
begin
if update(a)
begin
update TABB
set a = i.a
from inserted i,deleted d
where i.主键 = d.主键
and i.a <> d.a
and i.关联字段= TABB.关联字段
end
end
请楼上兄弟指教!