谢谢! 是不是将其写在出发器管理中的 CREATE TRIGGER [TRIGGER NAME] ON [opr_].[TEMP1] FOR INSERT, UPDATE, DELETE AS 之后?
CREATE TRIGGER t_temp1in ON temp1 FOR INSERT AS INSERT INTO test2.dbo.temp2 (EEE,FFF,GGG) SELECT AAA,BBB,CCC+DDD FROM INSERTED
用存储过程不如触发器,但如果变动TEMP1也用存储过程时,可以将插入TEMP2的处理放在同一个存储过程里,当修改TEMP1成功后,在想TEMP2中做相应的插入语句,但必须有ID来标示出刚写的数据记录: INSERT INTO test2.dbo.temp2 (EEE,FFF,GGG) SELECT AAA,BBB,CCC+DDD FROM temp2 where id = @id
是不是将其写在出发器管理中的
CREATE TRIGGER [TRIGGER NAME] ON [opr_].[TEMP1]
FOR INSERT, UPDATE, DELETE
AS
之后?
FOR INSERT
AS
INSERT INTO test2.dbo.temp2 (EEE,FFF,GGG)
SELECT AAA,BBB,CCC+DDD FROM INSERTED
INSERT INTO test2.dbo.temp2 (EEE,FFF,GGG)
SELECT AAA,BBB,CCC+DDD FROM temp2 where id = @id
--申明变量
declare @AAA int,@BBB char(6)
--调用存储过程
exec inserttemp2 @AAA,@BBB
注:
--inserttemp2要调用的存储过程名
--@AAA,@BBB,参数名。