Question

I am maintaining an audit table, where in I have a parent table and it s child table.I want to insert the primary key of the parent audit table into it s child audit table.
Should I be declaring a "before insert" instead of a "for insert" trigger. Here s my code:

CREATE trigger [trgAudtblChild] On [tblChild]
for Insert 
as
BEGIN

declare @serNo  bigint 
declare @expSerNo  int 
declare @postPercent  numeric  (12, 2) 
declare @prdSAPid  varchar  (50) 
declare @lastUpdatedBy  int 
declare @lastUpdatedOn  smalldatetime 

SELECT 
 --@serno = serno,
 @expSerNo = expSerNo ,
 @postPercent = postPercent ,
 @prdSAPid = prdSAPid ,
 @lastUpdatedBy = lastUpdatedBy ,
 @lastUpdatedOn = lastUpdatedOn
FROM INSERTED

select @serno = max(at_serno) from AT_tblParent

insert into AT_tblChild(serNo, expSerNo, postPercent
                       , prdSAPid, lastUpdatedBy, lastUpdatedOn
                       , change_column_index) values(
                                  @serNo, @expSerNo, @postPercent
                          , @prdSAPid, @lastUpdatedBy, @lastUpdatedOn
                          ,  INSERTED )

End
Return

上述代码不起作用,将表格放入交易中。

Answer 1

before trigger - 当您想要在数据被插入到表格之前截获数据时。

- 您的记录已经插入,但仍可以修改。

唯一的区别是,关于记录,实际上是否插入。

Back to the original Query

在上述您所提到的情况下,您不应使用 < kbd> Before Trigger 。当您的父表格记录在一些交易中插入时,您不应使用 < kbd> Before Trigger 。当您的父表格记录在一些交易中插入时,您会考虑一个案例,而同一交易会被回放。在这种情况下,它会为外国密钥限制而崩溃。因为您会尝试在插入时将外国密钥的父母表格记录引用到父表格中不存在的子表格中。

Back to the original Query

友情链接