select cast(3.14459 asnumeric(18,2))
结果为:3.14
selectconvert(decimal(18, 2), 3.14559)
结果为:3.15
select cast(3.14159 as decimal(10, 2))
结果为:3.14
select cast(3.14459 asnumeric(18,2))
结果为:3.14
selectconvert(decimal(18, 2), 3.14559)
结果为:3.15
select cast(3.14159 as decimal(10, 2))
结果为:3.14