关于sql money类型在读取时小于1的情况下

SELECT GameType, addr, CAST(t AS varchar) AS money 
    FROM (SELECT GameType, dbo.addQuota(GameType) AS addr,SUM(CAST(UpQuota AS money)) AS t 
         FROM CapQuota GROUP BY GameType) tt

用cast将money类型转换成varchar即可