–SELECT cast(10.982233 AS INT) – 10
–SELECT cast(10.776654 AS Money) – 10.7767
–SELECT cast(‘123.4’ AS INT) --报错:[SQL Server]在将 varchar 值 ‘123.4’ 转换成数据类型 int 时失败
–原因:cast()和函数convert()都不能执行四舍五入或者截断操作。
–SELECT cast(‘123.4’ AS DECIMAL(9, 4)) --123.4000
–SELECT cast(‘123.4’ AS DECIMAL(9)) --18
–SELECT CONVERT(VARCHAR(50), cast(1234.56 AS Money), 1) --1,234.56
–SELECT CONVERT(VARCHAR(50), cast(1234.56 AS Money), 2) --1234.5600