DECLARE @TB TABLE(COL FLOAT) INSERT @TB SELECT 1.5 UNION ALL SELECT 1.4 UNION ALL SELECT 23.3 UNION ALL SELECT 2451.6 UNION ALL SELECT 236.8SELECT CAST(ROUND(COL,0) AS INT) FROM @TB /* ----------- 2 1 23 2452 237 */
select cast(1.5 as numeric)
SELECT ROUND(1.5,0) UNION SELECT ROUND(14,0) UNION SELECT ROUND(23.3,0) UNION SELECT ROUND(2451.6,0) UNION SELECT ROUND(236.8,0)
select cast(1.5 as numeric)
结果:
2
DECLARE @TB TABLE(COL FLOAT)
INSERT @TB
SELECT 1.5 UNION ALL
SELECT 1.4 UNION ALL
SELECT 23.3 UNION ALL
SELECT 2451.6 UNION ALL
SELECT 236.8SELECT CAST(ROUND(COL,0) AS INT) FROM @TB
/*
-----------
2
1
23
2452
237
*/
SELECT ROUND(14,0) UNION
SELECT ROUND(23.3,0) UNION
SELECT ROUND(2451.6,0) UNION
SELECT ROUND(236.8,0)