cursor

最新推荐文章于 2025-08-18 07:17:11 发布

原创最新推荐文章于 2025-08-18 07:17:11 发布 · 484 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#user #go

数据库专栏收录该内容

6 篇文章

订阅专栏

本文介绍了一个使用存储过程来更新玩家在游戏中头击率和命中率的示例。该过程通过遍历每个用户的战斗数据，计算特定武器（排除手榴弹和刀具）的头击率和命中率，并将结果更新到用户表中。

CREATE procedure sp_headshotrate_Hitrate_vip
as
declare @headshot numeric(10,2), @hit numeric(10,2),@dv_user_id numeric,@kills numeric(10,2),@shots numeric(10,2),@headshotrate numeric(10,2),@hitrate numeric(10,2)
begin
Declare cur_user cursor for
select sum(headshots) as headshot,sum(kills) as kills,dv_user_id from fight_week_weapon where weaponname<>'grenade'   group by dv_user_id
OPEN cur_user
FETCH NEXT FROM cur_user INTO @headshot,@kills,@dv_user_id
WHILE @@FETCH_STATUS = 0
BEGIN
  if (@kills<1)
   set @headshotrate=0
  else
   set @headshotrate=convert(numeric(10,2),@headshot)/convert(numeric(10,2),@kills) * 100

update [user] set vip_headshotrate=@headshotrate where dv_user_id=@dv_user_id

FETCH NEXT FROM cur_user INTO @headshot,@kills,@dv_user_id
END
close cur_user
deallocate cur_user

Declare cur_user cursor for
select sum(hits) as hit,sum(shots) as shots,dv_user_id from fight_week_weapon where weaponname<>'knife' group by dv_user_id
OPEN cur_user
FETCH NEXT FROM cur_user INTO @hit,@shots,@dv_user_id
WHILE @@FETCH_STATUS = 0
BEGIN
  if (@shots<1)
   set @hitrate=0
  else
   set @hitrate=convert(numeric(10,2),@hit)/convert(numeric(10,2),@shots) * 100

update [user] set vip_hitrate=@hitrate where dv_user_id=@dv_user_id

FETCH NEXT FROM cur_user INTO @hit,@shots,@dv_user_id
END
close cur_user
deallocate cur_user
end