日期:2014-05-17 浏览次数:20627 次
在线等待请高手帮忙
--try: create trigger tri_one on 明细录 for insert,update as delete zm_rkxx from zm_rkxx a,deleted b where a.入库编号=b.入库编号 insert into zm_rkxx select 入库编号,sum(商品数量*成本单价),getdate() from inserted group by 入库编号 go