34,576
社区成员
发帖
与我相关
我的任务
分享
CAST(列名 AS FLOAT)
--> 测试数据:[tb]
IF OBJECT_ID('[tb]') IS NOT NULL DROP TABLE [tb]
GO
CREATE TABLE [tb]([col] NUMERIC(12,5))
INSERT [tb]
SELECT 112.3 UNION ALL
SELECT 54665.65879 UNION ALL
SELECT 456.02046 UNION ALL
SELECT 654.265 UNION ALL
SELECT 40354.10203 UNION ALL
SELECT 145 UNION ALL
SELECT 6546463
--------------开始查询--------------------------
SELECT * FROM [tb]
SELECT CAST(col AS FLOAT) FROM [tb]
----------------结果----------------------------
/*
(无列名)
112.3
54665.65879
456.02046
654.265
40354.10203
145
6546463
*/
numeric(18,5)
decimal(18,5)
ROUND()
CEILING()
FLOOR()
seelct cast (col as decimal(18,5)) from tb