问个触发器获取更新前数据的问题

[qq_34067000]

select @temp=i.Mid, @quota=i.SQuota, @quota1=d.SQuota from inserted i,deleted d where i.ProductID=d.ProductID


UPDATE m_member SET p1=@quota,d1=@quota1 where PID=@temp

为什么我p1,d1二个值是一样的？？？不是一个修前改的数据，一个修改后的数据吗？

[大葡萄八块一斤]

把你创建触发器的整个内容发一下才知道，你这个发的看不出什么

[qq_34067000]

ALTER TRIGGER [dbo].[triggerUpdateProduct]
ON [dbo].[p_product]
AFTER INSERT,UPDATE,DELETE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

declare @temp int
declare @status int
declare @quota decimal
declare @quota1 decimal
declare @productid int
declare @ProductType int
declare @id int

select @temp=i.Mid,@status=i.Status,@quota=i.SQuota,@productid=i.ProductID,@ProductType=i.ProductType,@quota1=d.SQuota from inserted i,deleted d where i.ProductID=d.ProductID


UPDATE m_member SET p1=@quota,d1=@quota
END

[qq_34067000]

ALTER TRIGGER [dbo].[triggerUpdateProduct]
ON [dbo].[p_product]
AFTER INSERT,UPDATE,DELETE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

declare @temp int
declare @status int
declare @quota decimal
declare @quota1 decimal
declare @productid int
declare @ProductType int
declare @id int

select @temp=i.Mid,@status=i.Status,@quota=i.SQuota,@productid=i.ProductID,@ProductType=i.ProductType,@quota1=d.SQuota from inserted i,deleted d where i.ProductID=d.ProductID


UPDATE m_member SET p1=@quota,d1=@quota1 where PID=@temp
END
这个是完整的

[qq_34067000]

AFTER INSERT,UPDATE,DELETE

其实这里只有UPDATE起作用

[非专业开发Five]

当你修改的时候这个值没有变化的时候就会出现前后一致的值啊。我不太相信你只有做这一个字段的数据更新。

[大葡萄八块一斤]

如楼上所说的，你如果改的值是相同的，那肯定是一样的了，要做下处理才行

ALTER TRIGGER [dbo].[triggerUpdateProduct]
   ON  [dbo].[p_product]
   AFTER UPDATE
AS 
IF UPDATE(SQuota) --判断更新该字段才处理
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

 declare @temp int 
 declare @status int
 declare @quota decimal
 declare @quota1 decimal
 declare @productid int
 declare @ProductType int
 declare @id int

 select @temp=i.Mid,@status=i.Status,@quota=i.SQuota,@productid=i.ProductID,@ProductType=i.ProductType,@quota1=d.SQuota from inserted i,deleted d where i.ProductID=d.ProductID
 IF @quota<>@quota1 --更新的值不一样才更新
    UPDATE m_member SET p1=@quota,d1=@quota1 where PID=@temp
END

[qq_34067000]

哪位高人指点一二