select convert(varchar(100),cast(1.12345 as money),1) 结果用千分数表示并且保留5位小数怎么修改呢?
------解决方案--------------------
- SQL code
select ltrim(convert(decimal(18,5),1.12345*1000.0))+'/1000'
                  select ltrim(convert(decimal(18,5),1.12345*1000.0))+'/1000'