Update Proposals set ProposalName = '111111111' Where proposalautoid < 1000Also report this error.
你有触发器吗? 估计是你的for update触发器所引起的。
如果有触发器,请改为下面的形式:CREATE TRIGGER trname ON Proposals FOR update AS update YouTable set ProposalName=tem.ProposalName from inserted tem where YouTable.proposalautoid=tem.proposalautoid go
Where proposalautoid < 1000Also report this error.
估计是你的for update触发器所引起的。
FOR update
AS
update YouTable set ProposalName=tem.ProposalName from inserted tem where YouTable.proposalautoid=tem.proposalautoid
go
alter table 表名 disable trigger 触发器名
AutoSetDataTime