create table a
(a int,b int,c int,d int)
create table b
(c int,d int,f varchar,g varchar)
insert b select 1,2,'a','b'
union all select 2,3,'b','c'
create table c
(a int,b int,f varchar,g varchar)
select * from a
select * from b
select * from c
create trigger triname on a
for insert
as
begin
insert c select aa.a,aa.b,bb.f,bb.g from a aa,b bb where aa.c=bb.c and aa.d=bb.d
end
insert a select 1,2,1,2
(a int,b int,c int,d int)
create table b
(c int,d int,f varchar,g varchar)
insert b select 1,2,'a','b'
union all select 2,3,'b','c'
create table c
(a int,b int,f varchar,g varchar)
select * from a
select * from b
select * from c
create trigger triname on a
for insert
as
begin
insert c select aa.a,aa.b,bb.f,bb.g from a aa,b bb where aa.c=bb.c and aa.d=bb.d
end
insert a select 1,2,1,2
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货