触发器的怪问题?求救

[top99010]

在A表插入一条记录后触发插入相关信息到B表,B表的数据成功生成,但A表新增的数据并没有写进数据库中!很郁闷,求救!

[yesyesyes]

instead of insert触发

[昵称被占用了]

贴出代码

[samson_www]

用select * from inserted查看一下

[top99010]

Create Trigger Insert_Plan on Sale
INSTEAD OF INSERT
AS
DECLARE @CID Varchar(4),
@Ind Varchar(17)
Select @CID=I.CompactID,@Ind=I.IndentID from INSERTED I
INSERT INTO AuditingPlan(FlowID,IndPactID,UserID)
select @CID,@Ind,S.UserID
from Auditing S where @CID=S.CompactID AND S.AudOrder=1
在Sale插入记录后触发器在AuditingPlan表插入了相应记录,但Sale表新增的记录没有写入数据库中,请给位大虾指点.

[paoluo]

try：

Create Trigger Insert_Plan on Sale
For INSERT
AS
Insert Into AuditingPlan(FlowID,IndPactID,UserID) Select A.CompactID,A.IndentID,B.UserID From Inserted A Inner Join Auditing B On A.CompactID=B.CompactID And B.AudOrder=1
GO

[paoluo]

1.用FOR INSERT ，不用INSTEAD OF INSERT

2.
DECLARE @CID Varchar(4),
@Ind Varchar(17)
Select @CID=I.CompactID,@Ind=I.IndentID from INSERTED I

這種寫法，考慮不周，如果一次插入多條數據，就會有問題。