34,590
社区成员
发帖
与我相关
我的任务
分享
CREATE TRIGGER RMSETB_INSERT_TR_C ON RMSETB
AFTER INSERT
AS
BEGIN
BEGIN TRAN
UPDATE RMSETB SET ETB980=DEA024,ETB981=DEA024*B.ETB008 FROM RMSETB B
INNER JOIN TPADEA ON ETB003=DEA001
INNER JOIN inserted I ON B.ETB000=I.ETB000 AND B.ETB001=I.ETB001 AND B.ETB002=I.ETB002
IF @@ERROR<>0
ROLLBACK TRAN
ELSE
COMMIT TRAN
END