在更新触发器中写入冲突 [英] Write Conflict in the update Trigger

问题描述

Record was not updated because of a write conflict.
Fields with conflicts:

Field Name  Current Value
Stored in Table Original Value in Field Updated_On  02/08/2013 12:08:21 24 pm   02/08/2013 12:00:00 00 am

代码： -

code:-

IF(UPDATE(Interview_Date_And_Time))
BEGIN
INSERT INTO Interview_History(Interview_Id,Column_Name,Old_Value,New_Value,Updated_On,Updated_By) VALUES (@InterviewID,'Interview Date And Time',@OldValueInterviewDateAndTime,@InterviewDateAndTime,@UpdatedOn,@UpdatedBy);
END

推荐答案

这是字体结束问题。更新后的字段，但未授予更新值的权限。

it is font end issue.for the updated on field and didn't give permission to update the value.

这篇关于在更新触发器中写入冲突的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！