-
哔哔one
CREATE TRIGGER TRIGGER_NAME ON productFOR insert ASDECLARE @编号 VARCHAR(50)DECLARE @商品名称 VARCHAR(200)DECLARE @类型 VARCHAR(50)BEGIN TRANDECLARE product_cursor CURSOR FORSELECT 编号,商品名称,类型 FROM insertedOPEN product_cursorFETCH NEXT FROM product_cursor INTO @编号, @商品名称, @类型WHILE @@FETCH_STATUS =0BEGINinsert into sale(编号,商品名称,类型,售价,标价,数量,联系人) values(@编号,@商品名称,@类型,NULL,NULL,0,'')FETCH NEXT FROM product_cursor INTO @编号, @商品名称, @类型ENDCOMMIT
-
慕村9548890
create trigger product_inserton product after insertasinsert into sale(编号,商品名称,类型,售价,标价,数量,联系人)select 编号,商品名称,类型,null,null,0,nullfrom insertedgo
-
德玛西亚99
我建了两个表:product(pno,pname,ptype,pcount),分别是编号 商品名称 类型 数量,sale(pno,pname,ptype,price,biaojia,pcount,contact)分别是编号 商品名称 类型 售价 标价 数量 联系人。触发器如下:create trigger p_son productafter insertas begindeclare @no char(10)declare @name char(20)declare @t char(10)set @no=(select pno from inserted)set @name=(select pname from inserted)set @t=(select ptype from inserted)insert into sale values(@no,@name,@t,'','','0','')end在执行一次插入操作:insert into productvalues('1','baidu','web','1')成功!