怎么让程序退出去?现在是如果@UserPoints>16,它会都执行一次,原意是执行了一个后就退出来的!
If @UserPoints>=16
BEGIN
UPDATE [tb_User] set score=score+300 where UserId=@UserID
return
END If @UserPoints>=14
BEGIN
UPDATE [tb_User] set score=score+100 where UserId=@UserID
return
END If @UserPoints>=12
BEGIN
UPDATE [tb_User] set score=score+50 where UserId=@UserID
return
END
If @UserPoints>=16
BEGIN
UPDATE [tb_User] set score=score+300 where UserId=@UserID
return
END If @UserPoints>=14
BEGIN
UPDATE [tb_User] set score=score+100 where UserId=@UserID
return
END If @UserPoints>=12
BEGIN
UPDATE [tb_User] set score=score+50 where UserId=@UserID
return
END
BEGIN
UPDATE [tb_User] set score=score+300 where UserId=@UserID
return
END
else
begin
If @UserPoints>=14
BEGIN
UPDATE [tb_User] set score=score+100 where UserId=@UserID
return
END
else
If @UserPoints>=12
BEGIN
UPDATE [tb_User] set score=score+50 where UserId=@UserID
return
END
end
BEGIN
UPDATE [tb_User] set score=score+300 where UserId=@UserID
return
END
If @UserPoints>=14 and @UserPoints<16
BEGIN
UPDATE [tb_User] set score=score+100 where UserId=@UserID
return
END
If @UserPoints>=12 and @UserPoints<14
BEGIN
UPDATE [tb_User] set score=score+50 where UserId=@UserID
return
END