简单的触发器例子

create trigger insertMemberMoney

on MemberMoney

after INSERT
AS
DECLARE @moneyType INT
DECLARE @money decimal
SELECT @moneyType=MoneyType,@money=[money] FROM INSERTED
 

IF @moneyType=3  --充值成功
BEGIN
    update member

set RechargeAccount=RechargeAccount+@money,TempRechargeAccount =

TempRechargeAccount+@money

where id=(select memberid from inserted)

END
ELSE IF @moneyType=4  --返奖
BEGIN
    --todo
set
    
where id=(select memberid from inserted)
END