create trigger my_trig on insert as begin update table2 set state = 1 where 关键字 = (select 关键字 from inserted) end
create trigger my_trig on table1 for insert as begin update table2 set state = 1 where 关键字 = (select 关键字 from inserted) end
--假设 table2 中的字段 col 与 table1 相关联,则: create trigger tri_test on table1 for insert as begin update table2 set state=1 where col=(select col from inserted) end
create trigger tri_name on table1 for insert as begin update table2 set state=1 where col1=(select col1 from inserted) end
as
begin
update table2 set state = 1 where 关键字 = (select 关键字 from inserted)
end
as
begin
update table2 set state = 1 where 关键字 = (select 关键字 from inserted)
end
create trigger tri_test
on table1
for insert
as
begin
update table2 set state=1 where col=(select col from inserted)
end
on table1
for insert
as
begin
update table2 set state=1 where col1=(select col1 from inserted)
end