create trigger tr_b on b
after insert
as
begin
insert c(货单号,商品简称,运费)
select a.货单号,a.商品简称,i.运费
from a join inserted i on a.订单号=i.订单号
end
after insert
as
begin
insert c(货单号,商品简称,运费)
select a.货单号,a.商品简称,i.运费
from a join inserted i on a.订单号=i.订单号
end
for insert
as
insert c
select a.订单号,
a.货单号,
a.商品简称,
i.运费
from insert i ,ta a where a.订单号=i.订单号
select a.订单号, a.货单号, a.商品简称, a.运费
from a join inserted b on a.订单号 = b.订单号
for insert insert c
select a.订单号,a.货单号,a.商品简称,b.运费
from A, inserted b, where a.订单号=b.订单号
?
after insert
as
begin
insert c
select a.订单号,a.货单号,a.商品简称,i.运费
from a join inserted i on a.订单号=i.订单号
end
for insert,update
as
insert C
select a.订单号,a.货单号,a.商品名称,a.商品简称,b.运费
from A join inserted b on a.订单号=b.订单号
GO
for insert
as
begin
insert into C
select A.*,B.运费 from A表 join B表 on A.订单号=B.订单号
end
for insert
as
insert c
select a.订单号,
a.货单号,
a.商品简称,
i.运费
from inserted i ,ta a where a.订单号=i.订单号
for insert
as
begin
insert c
select
a.订单号,a.货单号,a.商品简称,i.运费
from
insert i ,tb a where a.订单号=i.订单号
end
for insert insert c
select a.订单号,a.货单号,a.商品简称,b.运费
from A, inserted b where a.订单号=b.订单号上面的多了‘,’
for insert
as
begin
insert into C(订单号,货单号,商品简称,运费)
select A.*,B.运费 from A表 join B表 on A.订单号=B.订单号
end
insert 写错了
我在9楼已经更正
---trycreate trigger tri_g on B
instead of insert
as
begin
insert into C
select a.*,b.运费 from A join inserted b on
a.订单号=b.订单号
end
on b
after insert
as
declare @num varchar(20) --订单号
declare @proNo varchar(20)--货单号
declare @descript nvarchar(1000) --商品描述
declare @transMoney decimal--运费
set @num=(select 订单号 from inserted)
if exists(select 订单号 from a where 订单号=@num)
begin
set @proNo=(select 货单号 from a where 订单号=@num)
set @descript=(select 商品描述 from a where 订单号=@num)
--上面的两行代码 可以这样写
select @proNo=货单号,@descript=商品描述 from a where 订单号=@num
set @transMoney=(select 运费 from inserted)
insert into c(订单号,货单号,商品描述,运费) values(@num,@proNo,@descript,@transMoney)
end