![SQLSERVER 中 CEILING 失效](https://img-ask.csdn.net/upload/201806/29/1530266980_556396.jpg
WITH aa AS
(
SELECT CAST((0.12345679) AS DECIMAL(22,8)) * CAST(0.11111111 AS DECIMAL(22,8)) AS a
,CAST((0.12345679) AS DECIMAL(22,8)) * CAST(0.11111111 AS DECIMAL(22,8)) * 100000000 AS b
,CAST(CAST((0.12345678) AS DECIMAL(12,8)) * CAST(0.11111111 AS DECIMAL(12,8)) AS float) AS E
,CEILING
(
CAST(CAST((0.12345678) AS DECIMAL(12,8)) * CAST(0.11111111 AS DECIMAL(12,8)) AS decimal(10,9)) * 100000000
) as c
)
SELECT *, CEILING(b) as CEILING_b
FROM aa