有一个表,二个字段,
id(int) acount(float)
1 310000026549.0
2 310000026550.0当执行select id, cast(acount as varchar(12)) as acount from table1时得到的就
1 3.1e+011
2 3.1e+011请问如何将这个FLOAT字段转换成VARCHAR,而且不是用科学计数法显示。即
1 3100000026549
2 3100000025650
id(int) acount(float)
1 310000026549.0
2 310000026550.0当执行select id, cast(acount as varchar(12)) as acount from table1时得到的就
1 3.1e+011
2 3.1e+011请问如何将这个FLOAT字段转换成VARCHAR,而且不是用科学计数法显示。即
1 3100000026549
2 3100000025650
Insert into @t
select 1 , 310000026549.0
union select 2 , 310000026550.0select id, cast(Convert(Decimal(18,0),acount) as varchar) as acount from @t
select id, left(convert(varchar(20),acount),12) as acount from table1