create trigger trig_InsertTransInfo on TransInfo for insert as begin declare @cardId char(10) declare @type char(4) declare @money money select @cardId=CardId,@type=transType,@money=transMoney from inserted if(@type='支取') update bank set CurrentMoney=CurrentMoney-@money where C
