1.效果
select cast(round(12.1255587156,2) as numeric(20,2)) as value
2.将其他类型的数据转化为 字符串类型
-- 结果是float类型
select cast(round(12.1255587156,2) as numeric(20,2)) as value-- 结果是 字符串类型了
select convert(varchar,cast(round(12.1255587156,2) as numeric(20,2)) ) as value