SQL 技巧 只取小數3位,且只顯示小數後非0的數字

SELECT

CONVERT(VARCHAR,CAST(CAST(23.3457 * 1000 AS INT) AS FLOAT) /1000 )

結果==>23.345

SELECT

CONVERT(CHAR(20),CAST(CAST(CAST(8 * 1000 AS INT) AS FLOAT) /1000 AS VARCHAR)+'%')

結果==>8%