34,575
社区成员
发帖
与我相关
我的任务
分享
SELECT CAST(1.0*1865/1000 AS NUMERIC(10,3))
DECLARE @t TABLE (v INT)
INSERT INTO @t VALUES (1865)
SELECT v,CAST(v/1000.0 AS DECIMAL(10,3)) AS v2 FROM @t
/*
v v2
----------- ---------------------------------------
1865 1.865
*/
DECLARE @t TABLE (v INT)
INSERT INTO @t VALUES (1865)
SELECT v,v/1000.0 AS v2 FROM @t
/*
v v2
----------- ---------------------------------------
1865 1.865000
*/