create table a(id int identity(1,1),name varchar(20))
create table b(id int identity(1,1),aid int,name varchar(20))
gocreate trigger trg_a
on a
for insert
as
insert into b select id,name from inserted
goinsert into a select 'aaaa'
select * from a
select * from b
godrop trigger trg_a
drop table a,b
go
create table b(id int identity(1,1),aid int,name varchar(20))
gocreate trigger trg_a
on a
for insert
as
insert into b select id,name from inserted
goinsert into a select 'aaaa'
select * from a
select * from b
godrop trigger trg_a
drop table a,b
go
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货