ALTER TRIGGER Bargaining_sTrigger
ON dbo.Bargaining
--当转账记录产生后
FOR INSERT
AS
declare @sBargaining_Revolution varchar(50),--转出账户
@sBargaining_Shiftto varchar(50),--转入账户
@sBargaining_Money varchar(50), --转出金额(转入金额)
@sMonly int,--转出账户在账目转出前的余额
@aMonly int--转入账户在账目转入前的余额
--查询最新转账数据,包括:转出账户,转入账户,转出金额
select @sBargaining_Revolution=Bargaining_Revolution,
@sBargaining_Shiftto=Bargaining_Shiftto,
@sBargaining_Money=Bargaining_Money
From inserted
--查询转出账户在账目转出前账上余额
select teacherMonly into @sMonly From Administrators Where teacherID=@sBargaining_Revolution
--查询转入账户在账目转入前账上余额
select teacherMonly into @aMonly From Administrators Where teacherID=@sBargaining_Shiftto
IF @sMonly>@sBargaining_Money Then
Begin
--更新转出账户账上余额
Update Administrators Set teacherMonly=@sMonly-@sBargaining_Money Where teacherID=@sBargaining_Revolution
--更新转入账户账上余额
Update Administrators Set teacherMonly=@aMonly+@sBargaining_Money Where teacherID=@sBargaining_ShifttoEnd
select .... from ... where 1=2以及insert into Bargaining
select * from BargainingBackup这些都会触发触发器,不要仅仅认为有一条记录被插入。