如题?create trigger tri_info_insert1
on Table_2
for insert
as
begin insert Table_1 select * from inserted where a='1'
and insert Table_3 select * from inserted where a='3'
end
go这样为什么不行
on Table_2
for insert
as
begin insert Table_1 select * from inserted where a='1'
and insert Table_3 select * from inserted where a='3'
end
go这样为什么不行
on Table_2
for insert
as
begin
begin
insert Table_1 select * from inserted where a='1'
end
begin
insert Table_3 select * from inserted where a='3'
end
end
go
on Table_2
for insert
as
begin insert Table_1 select * from inserted where a='1'
and insert Table_3 select * from inserted where a='3'
end
go
楼主把SQL当程序语言了。create trigger tri_info_insert1
on Table_2
for insert
as
begin insert Table_1 select * from inserted where a in ('1','3')
end
go