sql利用存储过程修改表中得分

create procedure  [dbo].[proc_hj]
@hj_id varchar(20),
@dj_name  varchar(20),
@jb_name varchar(20)
as
update H_J
set H_J.HJ_score=HJ_DJ.DJ_score*HJ_JB.HJ_jb_xishu
from H_J,HJ_DJ,HJ_JB
where H_J.DJ_id=HJ_DJ.DJ_id  and H_J.HJ_jb_id=HJ_JB.HJ_jb_id
and HJ_JB.HJ_jb_name=@jb_name and  HJ_DJ.DJ_name=@dj_name  and

  H_J.HJ_id=@hj_id 

create procedure  [dbo].[proc_jd]
@jd_id varchar(20),
@cg_name varchar(20),
@jb_name varchar(20)
as
update J_D
set J_D.JD_score=CG_DJ.CG_xishu*JD_JB.JB_score
from J_D,CG_DJ,JD_JB
where J_D.CG_id=CG_DJ.CG_id  and J_D.JB_id=JD_JB.JB_id
and JD_JB.JB_name=@jb_name and  CG_DJ.CG_name=@cg_name 
and J_D.JD_id=@jd_id 

create  procedure  [dbo].[proc_lx]
@lx_id varchar(20),
@ly_name  varchar(20),
@xz_name  varchar(20),
@money float
as
update L_X
set L_X.LX_score=KT_LY.LY_score*KT_XZ.XZ_xishu*LX_money
from L_X,KT_LY,KT_XZ
where  L_X.LY_id=KT_LY.LY_id  and L_X.XZ_id=KT_XZ.XZ_id
and  KT_LY.LY_name=@ly_name  and KT_XZ.XZ_name=@xz_name and  
  L_X.LX_id=@lx_id and L_X.LX_money=@money