34,590
社区成员
发帖
与我相关
我的任务
分享
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
最好给出完整的表结构,测试数据,计算方法和正确结果.