27,579
社区成员
发帖
与我相关
我的任务
分享
UPDATE
fc_rk_jl_t
SET
JE=sl*cast(dj as decimal(18,4))
where
fc_rk_id in (select id from fc_rk_t where BH='富-2011-05-0091') and dj='360.0000'
SET JE=sl*cast(dj as numeric(18,4))
UPDATE fc_rk_jl_t
SET JE=sl*convert(decimal(18,4),dj)
where fc_rk_id in (select id from fc_rk_t where BH='富-2011-05-0091') and dj='360.0000'