字段为id,存取的值有1,1.0,1.09。。。。。现在统一取出结果为1.0 select left(cast(id as DECIMAL(18,6) ) , charindex('.',cast(id as DECIMAL(18,6) )) + 1) 转载于:https://www.cnblogs.com/wxcmfz/p/7478993.html