select round(1075*(1-46/100.0),0) from dbo.Pl where id='1079' 输出结果:581.000000 select round(SJ*(1-discount/100.0),0) from dbo.Pl where id='1079' 输出结果:580 -------------------------------------------------------------- 上面 SJ=1075 , discount=46 数据类型:real