Create Trigger [在线送积分] ON dbo.[MEMB_STAT]
After Update
As
        declare @memb___id varchar(10)
        declare @ConnectStat tinyint
        declare @ConnectTM datetime
        declare @DisConnectTM datetime
        declare @ConnectStat2 tinyint
        declare @DisConnectTM2 datetime
        declare @AddMoney int
       
select        @memb___id=memb___id,
        @ConnectStat=ConnectStat,
        @ConnectTM=ConnectTM,
        @DisConnectTM=DisConnectTM
from Inserted
select        @ConnectStat2=ConnectStat,
        @DisConnectTM2=DisConnectTM
from Deleted

IF (@ConnectStat < @ConnectStat2) and (@DisConnectTM > @DisConnectTM2) and (@ConnectTM < @DisConnectTM)
Begin
        Set @AddMoney = datediff(minute,@ConnectTM,@DisConnectTM)*50000---这个数字你自己定，想发多少你自己定积分哦
        UpDate Warehouse set [money]=(case when 2000000000-@AddMoney >[money] then [money]+@AddMoney else 2000000000 end)
        where accountid=@memb___id
End
Go