CREATE TRIGGER kkk ON table2
FOR UPDATE,insert
AS
if update(team_name)
begin
begin tran
if (select count(*) from deleted)>0 then
begin
update table1
set term_a = insertd.term_name from inserted,deleted
where deleted.primay key=term_a.primay key
end
'说明你仅仅插入了数据
if (select count(*) from deleted)<0 then
begin
update term_a
set term_a=insertd.term_name
from inserted
where 连接外间
end
CREATE TRIGGER 你的触发器名 ON table2
FOR UPDATE
AS
if update(team_name)
begin
begin tran
declare @Key int(这个数据类型是我猜的,你按你的实际类型修改)
select @key = 你的关联字段 from deleted
update term_a = term_name from inserted where 你的关联字段 = @key
if @@error<>0
rollback tran
else
commit tran
end