有两个表 结构如下t1
a b c d e(PK)-------------------------------t2
a bb cc
当t1表插入记录的时候根据t1.a=t2.a 将t2的bb cc插入分别更新t1的 b 跟c栏位。
触发器要怎么写比较好呢?
a b c d e(PK)-------------------------------t2
a bb cc
当t1表插入记录的时候根据t1.a=t2.a 将t2的bb cc插入分别更新t1的 b 跟c栏位。
触发器要怎么写比较好呢?
for insert
as
update t1
set b = bb,
c=cc
from t1,t2
where t1.a=t2.a
create trigger my_trigger on t1
for insert
as
update t1
set b = bb,
c=cc
from t1,t2,inserted i
where t1.a=i.a and i.a=t2.a
create trigger trigger_name on t1
for insert
as
update t1 set b=bb, c=cc
from inserted join t2 on t2.a=inserted.a
as
begin
update t2
set bb = t.b,
cc = t.c
from t2 , inserted t
where t2.a = t.a
end
go
ON t1
FOR INSERT
as
begin
update t
set bb = i.b,
cc = i.c
from t2 t
join inserted i
where t.a = i.a
end
go
DROP TRIGGER 你的数据库名.reminder1
GO
CREATE TRIGGER reminder1
ON 你的数据库名.t1
AFTER INSERT
update t1
set b= t2.bb,
c=t2.cc
from t2,t1
where t2.a= t1.aGO