select
cast
(
3.14459
as
numeric
(
18
,
2
))
结果为:3.14
select
convert
(
decimal
(
18
,
2
),
3.14559
)
结果为:3.15
select
cast
(
3.14159
as
decimal
(
10
,
2
))
结果为:3.14
版权声明：本文为Programmer_FuQiang原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。