select cast(cast('1.526207675E7'as float)as numeric(20,2)) 字符型先转float,再转numeric 转载于:https://www.cnblogs.com/liufei88866/archive/2011/11/07/2239320.html