测试环境如下: drop table test_a go drop table test_b go create table test_a (a int identity(1,1), b int) go create table test_b (a int, b int) go insert test_a values (20) insert test_a values (17) insert test_a values (1) go insert test_b values (4,1) insert test_b values (2,1) insert test_b values (3,1) go create trigger ins_another on test_a for insert as insert into test_b select * from inserted select * from test_b 测试证明真确
drop table test_a
go
drop table test_b
go
create table test_a (a int identity(1,1), b int)
go
create table test_b (a int, b int)
go
insert test_a values (20)
insert test_a values (17)
insert test_a values (1)
go
insert test_b values (4,1)
insert test_b values (2,1)
insert test_b values (3,1)
go
create trigger ins_another on test_a
for insert
as
insert into test_b select * from inserted
select * from test_b
测试证明真确