2012. 4. 23. 17:25
MSSQL
결과값에 자리수를 표시하는 방법(Money)
select convert(varchar, convert(money, 100000000), 1)
select Replace(convert(varchar, convert(money, 100000000), 1), '.00','')
----------------
결과값
100,000,000.00
select Replace(convert(varchar, convert(money, 100000000), 1), '.00','')
----------------
결과값
100,000,000
