日期:2014-05-18 浏览次数:20501 次
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'
------解决方案--------------------
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'