update set fields3=cast(cast(cast(field1 as numeric(10,1))/field2*100 as numeric(10,1)) as varchar(10))+'%'如果光要显示:
select field1,field2,cast(cast(cast(field1 as numeric(10,1))/field2*100 as numeric(10,1)) as varchar(10))+'%' from 表
select field1,field2,cast(cast(cast(field1 as numeric(10,1))/field2*100 as numeric(10,1)) as varchar(10))+'%' from 表
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货