--try:
--这个不用sp,就用触发器就可以了CREATE TRIGGER tri_a
ON A
FOR insert AS
insert b select * from inserted
--这个不用sp,就用触发器就可以了CREATE TRIGGER tri_a
ON A
FOR insert AS
insert b select * from inserted
调试欢乐多
for insert
as
insert B表(商品ID,商品单位)
select a.商品id,a.商品单位
from inserted a left join B表 b on a.商品ID=b.商品ID
where b.商品ID is null
create trigger tr_insert on A for insert
as
insert B(商品ID,商品单位)
select A.商品id,A.商品单位
from inserted A
as
insert B(商品ID,商品单位)
select A.商品id,A.商品单位
from inserted
就没有语法错误
但触发器使用出现错误。