+ -
当前位置:首页 → 问答吧 → 触发器问题

触发器问题

时间:2011-09-07

来源:互联网

下面这哪里有问题,有什么问题,红字那应该怎么写 inserted 是张临时表

create trigger trg_pos_machine_after_insert
after insert 
on pos_machine
for each row
begin
declare @posno varchar(4)
select @posno = posno from inserted

insert into pos_receivedate(posno,itemno)
values( @posno,"会员资料")

insert into pos_receivedate(posno,itemno)
values( @posno,"商品条码")

insert into pos_receivedate(posno,itemno)
values( @posno,"商品资料")

insert into pos_receivedate(posno,itemno)
values( @posno,"店促商品")

insert into pos_receivedate(posno,itemno)
values( @posno,"店促档期")

insert into pos_receivedate(posno,itemno)
values( @posno,"DM商品")

insert into pos_receivedate(posno,itemno)
values( @posno,"DM档期")

insert into pos_receivedate(posno,itemno)
values( @posno,"员工资料")
end
;

作者: qrjmh0201   发布时间: 2011-09-07

insert into pos_receivedate(posno,itemno)
 values( new.posno,"会员资料")

作者: WWWWA   发布时间: 2011-09-07