如何更改号码？ [英] How to change the number?

问题描述

i will try to after 4 decimal point?
DECLARE @tbl TABLE (val float)
INSERT INTO @tbl SELECT 12.19
INSERT INTO @tbl SELECT 13.92
INSERT INTO @tbl SELECT 14.47
INSERT INTO @tbl SELECT 18.025
INSERT INTO @tbl SELECT 18.3
INSERT INTO @tbl SELECT 17.79
INSERT INTO @tbl SELECT 18.13
INSERT INTO @tbl SELECT 15.245
INSERT INTO @tbl SELECT 12.485
INSERT INTO @tbl SELECT 11.365
INSERT INTO @tbl SELECT 18.26
INSERT INTO @tbl SELECT 15.44
INSERT INTO @tbl SELECT 19.13
INSERT INTO @tbl SELECT 15.59
INSERT INTO @tbl SELECT 28.695
INSERT INTO @tbl SELECT 29.35
INSERT INTO @tbl SELECT 15.27
INSERT INTO @tbl SELECT 15.895
INSERT INTO @tbl SELECT 26.51


SELECT *,((abs(val)*10000) - CONVERT(INT,(abs(val)*10000))),cast(val*power(10,4) as int),val*power(10,4)
from @tbl

我尝试过的事情：



但是只有一个数字混淆了/>

What I have tried:

But only one number most of confusion

SELECT（（abs（cast（18.26 as float））* 10000） - CONVERT （INT，（abs（cast（18.26 as float））* 10000）））

SELECT ((abs(cast(18.26 as float))*10000) - CONVERT(INT,(abs(cast(18.26 as float))*10000)))

推荐答案

你可以试试CAST

You can try CAST

SELECT *,cast(((abs(val)*10000) - CONVERT(INT,(abs(val)*10000))) as Float), cast(val*power(10,4) as int),val*power(10,4)
from @tbl

这篇关于如何更改号码？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！