L
liuxr1978
Unregistered / Unconfirmed
GUEST, unregistred user!
我最近试用触发器，出现了点问题，希望高手指点。我的语句是这样写的
CREATE TRIGGER tr_update ON [dbo].[导入质量损失数量表]
FOR INSERT
AS
INSERT INTO m_国内质量损失数量(sybname,rq,wxlsl,thjsl)
SELECT 事业部名称,日期,维修量,退换量
FROM inserted
WHERE 事业部名称 IN (SELECT sybmc from dim_事业部)
执行数据插入时出现错误
Rows cannot be located for updating.Some values may be changed since
it was last read.
什么原因，
CREATE TRIGGER tr_update ON [dbo].[导入质量损失数量表]
FOR INSERT
AS
INSERT INTO m_国内质量损失数量(sybname,rq,wxlsl,thjsl)
SELECT 事业部名称,日期,维修量,退换量
FROM inserted
WHERE 事业部名称 IN (SELECT sybmc from dim_事业部)
执行数据插入时出现错误
Rows cannot be located for updating.Some values may be changed since
it was last read.
什么原因，