CONVERT(VARCHAR(20),CAST(10000000 AS MONEY),1)--带小数点 REPLACE(CONVERT(VARCHAR(20),CAST(10000000 AS MONEY),1),'.00','')--不带小数点
CONVERT(VARCHAR(20),CAST(10000000 AS MONEY),1)--带小数点 REPLACE(CONVERT(VARCHAR(20),CAST(10000000 AS MONEY),1),'.00','')--不带小数点
转载于:https://www.cnblogs.com/zhangxs/p/5345414.html