DECLARE @mny money
SET @mny = 123456.16
SELECT SUBSTRING(convert(varchar,cast(@mny as money),1),0,CHARINDEX('.',convert(varchar,cast(@mny as money),1)) ) as MONEY
money显示格式999,999,999
最新推荐文章于 2022-03-29 10:22:42 发布
DECLARE @mny money
SET @mny = 123456.16
SELECT SUBSTRING(convert(varchar,cast(@mny as money),1),0,CHARINDEX('.',convert(varchar,cast(@mny as money),1)) ) as MONEY