create table a(id int,name varchar(20),number int) create table b(id int,name varchar(20),number int)create trigger tri_a on a for insert as begin update b set b.number=b.number+i.number from b,inserted i where b.id=i.id insert into b select * from inserted i where not exists(select 1 from b where id=i.id) endinsert into a select 1,'商品',5select * from aselect * from b --a 1 商品 5 1 商品 5 --b 1 商品 10
create table a(id int,name varchar(20),number int) create table b(id int,name varchar(20),number int) insert into a select 1,'name',1 insert into b select 1,'name',1 Create Trigger update_a on a for insert as Begin update b set b.number=d.number+b.number from inserted d inner join b on d.id=b.id End insert into a select 1,'name',9select * from a select * from bdrop table a,b
create table b(id int,name varchar(20),number int)create trigger tri_a
on a
for insert
as
begin
update b set b.number=b.number+i.number from b,inserted i where b.id=i.id
insert into b select * from inserted i where not exists(select 1 from b where id=i.id)
endinsert into a select 1,'商品',5select * from aselect * from b
--a
1 商品 5
1 商品 5
--b
1 商品 10
create table b(id int,name varchar(20),number int)
insert into a select 1,'name',1
insert into b select 1,'name',1
Create Trigger update_a
on a
for insert
as
Begin
update b set b.number=d.number+b.number from inserted d inner join b on d.id=b.id
End
insert into a select 1,'name',9select * from a
select * from bdrop table a,b
/*
--表A
1 name 1
1 name 9
--表B1 name 10