sql server 数值的四舍五入

CAST(‘123.456‘ as decimal(38, 2)) ===>123.46 SELECT CAST(0.996123 AS DECIMAL(38,2)) 结果为 1.00 SELECT CAST(‘123.456‘ as dec(38, 2)) ===>123.46

 

sql server 数值的四舍五入

标签：