IF EXISTS(Select Name From Sysobjects Where Name='Tri_UPD_Jifen' And Type='TR') DROP TRIGGER Tri_UPD_Jifen go CREATE TRIGGER Tri_UPD_Jifen ON userinfo FOR UPDATE AS Declare @Jifen int Declare @ID int Select @Jifen=Jifen,@Id=Id From inserted while @Jifen<0 Begin update userinfo set jingbi=jingbi-1,Jifen=Jifen+3 where id=@id set @Jifen=@Jifen+3 End
IF EXISTS(Select Name From Sysobjects Where Name='Tri_UPD_Jifen' And Type='TR')
DROP TRIGGER Tri_UPD_Jifen
go
CREATE TRIGGER Tri_UPD_Jifen
ON userinfo
FOR UPDATE
AS
Declare @Jifen int
Declare @ID int
Select @Jifen=Jifen,@Id=Id From inserted while @Jifen<0
Begin
update userinfo set jingbi=jingbi-1,Jifen=Jifen+3 where id=@id
set @Jifen=@Jifen+3
End