CREATE TRIGGER trigger_webs_mis_hardware_excernent ON mis_hardware_excernent FOR INSERT, UPDATE AS IF EXISTS(SELECT * FROM inserted) and ont EXISTS(SELECT * FROM deleted) BEGIN INSERT mis_hardware_castoff(status_id,product_id,num,re,oldtab_name,oldtab_id,userid,input_date,use_date) select status_id,product_id,num,'','mis_hardware_excernent',id,userid,input_date,use_date from inserted END ELSE IF EXISTS(SELECT num FROM deleted) BEGIN UPDATE mis_hardware_castoff SET num=b.num FROM mis_hardware_castoff a,deleted b WHERE b.id=a.oldtab_id END
我的是7.0,我现在的做法是先删除,再重建.
***************************************************************************
有没有“SQL查询分析器”,如果有的话,可以先选择触发器所对应的表,编辑触发器,使用“ALTER TRIGGER”
我的是7.0,我现在的做法是先删除,再重建.
*********************************************************************
有没有“SQL查询分析器”,使用“ALTER TRIGGER”语句。
FOR INSERT, UPDATE
AS
IF EXISTS(SELECT * FROM inserted) and ont EXISTS(SELECT * FROM deleted)
BEGIN
INSERT mis_hardware_castoff(status_id,product_id,num,re,oldtab_name,oldtab_id,userid,input_date,use_date) select status_id,product_id,num,'','mis_hardware_excernent',id,userid,input_date,use_date from inserted
END
ELSE IF EXISTS(SELECT num FROM deleted)
BEGIN
UPDATE mis_hardware_castoff SET num=b.num FROM mis_hardware_castoff a,deleted b WHERE b.id=a.oldtab_id
END