sql中将字段转成Decimal

来源:互联网 发布:中国网络诈骗地图 编辑:程序博客网 时间:2024/04/28 06:05


update CHELIANG_MINGDAN set clmd_yunxuzaizhong = cast(clmd_yunxuzaizhong/1000 as decimal(14,4)) where clmd_yunxuzaizhong is not null

 


update CHELIANG_MINGDAN set clmd_carweight = cast(clmd_carweight/1000 as decimal(14,4)) where clmd_carweight is not null

原创粉丝点击