27,580
社区成员
发帖
与我相关
我的任务
分享
create table A(A1 varchar(10),A2 varchar(10),A3 varchar(10))
create table B(B1 varchar(10),B2 varchar(10))
create trigger tri_A
on A
after insert
as
begin
Insert into B(B1)
select A1 from inserted
end
INSERT INTO A(A1,A2,A3) Values('x01','x02','x03')
select * from A
/*
x01 x02 x03
*/
select * from B
/*
x01 NULL
*/
alter trigger insertTemp
on dbo.Test
for insert
as
select * into #temp from dbo.Test
iyang我没有用你所说的ab表 用了一张临时表 原理是一样的create trigger tri_A
on A
after insert
as
begin
Insert into B(B1)
select A1 from inserted
end