例如:如何将'2343.13'转换成2343.13
------解决方案--------------------
cast(col as numeric(12,2))
or
convert
------解决方案--------------------
- SQL code
select convert(numeric(10,2),'2343.13')
------解决方案--------------------
- SQL code
select cast('2343.13' as numeric(8,2)) n1,convert(numeric(8,2),'2343.13') n2n1 n2--------------------------------------- ---------------------------------------2343.13 2343.13(1 row(s) affected)