会是什么原因造成的?有时数据不正确。有时就执行一条(我都是一次性更新上百条或几十条记录)Update SouBao_SellFreezeG
Set
ISValidity='1'
Where
DealingID=@DealingID
And
ISValidity='0'SellFreezeG表的触发器
CREATE TRIGGER CreateOrderForm ON [dbo].[SouBao_SellFreezeG]
FOR UPDATE
AS
BEGIN
Declare @FreezeGMonery decimal(8,2),@UserID Int
Select @FreezeGMonery=FreezeGM,@UserID=ReplyUserID from inserted
Update SouBao_UserDealing
Set
GMonery=GMonery+@FreezeGMonery,
FreezeGMonery=FreezeGMonery-@FreezeGMonery
Where
UserID=@UserID
END有时我更新上百条记录。结果触发器只选择第一条更新记录的数据。
有时@UserID的数据跟我更新的记录数据对不上号。比较急。一个下午都在弄这个东西。
Set
ISValidity='1'
Where
DealingID=@DealingID
And
ISValidity='0'SellFreezeG表的触发器
CREATE TRIGGER CreateOrderForm ON [dbo].[SouBao_SellFreezeG]
FOR UPDATE
AS
BEGIN
Declare @FreezeGMonery decimal(8,2),@UserID Int
Select @FreezeGMonery=FreezeGM,@UserID=ReplyUserID from inserted
Update SouBao_UserDealing
Set
GMonery=GMonery+@FreezeGMonery,
FreezeGMonery=FreezeGMonery-@FreezeGMonery
Where
UserID=@UserID
END有时我更新上百条记录。结果触发器只选择第一条更新记录的数据。
有时@UserID的数据跟我更新的记录数据对不上号。比较急。一个下午都在弄这个东西。
set a.GMonery = a.GMonery + b.FreezeGMonery,a.FreezeGMonery = a.FreezeGMonery - b.FreezeGMonery
from SouBao_UserDealing a, (select ReplyUserID,sum(FreezeGM) as FreezeGMonery from inserted group by ReplyUserID) b
where a.UserID = b.ReplyUserID