SSQL 에서 천단위 표시를 할 때

SSQL 에서 천단위 표시를 할 때
SELECT CONVERT(VARCHAR(50), CAST(20000 AS MONEY), 1)
결과 => 20,000.00 (MONEY 타입은 소숫점 둘째자리까진 표현된다.
소수점을 없애고 싶다면 REPLACE 한다
SELECT REPLACE(CONVERT(VARCHAR(50), CAST(20000 AS MONEY), 1),’.00′, ”)
결과 => 20,000

Comments (98)

  1. Pingback: primewire.pics

  2. Pingback: lợn đẻ

  3. Pingback: mơ thấy đi chợ

  4. Pingback: mơ cãi nhau đánh con gì

  5. Pingback: mơ thấy cầu vồng

  6. Pingback: replicas omega

  7. Pingback: dallas cowboys cornhole set

  8. Pingback: mơ thấy mất của

  9. Pingback: mơ thấy bướm phụ nữ

  10. Pingback: https://rolexrolexwatches.icu/

  11. Pingback: Ritalin till salu

  12. Pingback: Köp Lyrica online

  13. Pingback: 메이저토토사이트

  14. Pingback: relx pod

  15. Pingback: Estate Planning

  16. Pingback: ดูบอล

  17. Pingback: en iyi canlı bahis siteleri

  18. Pingback: W88casino.net

  19. 응답

    Good day very nice web site!! Man .. Excellent .. Wonderful .. I’ll bookmark your web site and take the feeds additionally…I’m satisfied to search out numerous helpful info here in the publish, we need develop more strategies on this regard, thanks for sharing.

  20. Pingback: sagaming

  21. 응답

    We still can not quite believe I could end up being one of those reading through the important guidelines found on your site. My family and I are really thankful for the generosity and for providing me the chance to pursue my own chosen profession path. Thanks for the important information I managed to get from your web-site.

  22. Pingback: moon mandala

  23. Pingback: Thiết kế web

  24. Pingback: gửi hàng đi mỹ

  25. Pingback: Krypto tauschen

  26. Pingback: W88

  27. Pingback: linh tien song dang to

  28. Pingback: planowebdesigndirectory.com

  29. 응답

    I believe this is one of the such a lot vital information for me. And i am happy studying your article. But wanna commentary on few common issues, The site style is great, the articles is actually great :D. Just right job, cheers.

  30. Pingback: hawaiiwebdesigndirectory.com

  31. Pingback: situs judi qq online

  32. 응답

    wonderful post, very informative. I ponder why the opposite specialists of this sector don’t understand this. You should continue your writing. I’m sure, you have a great readers’ base already!

  33. 응답

    I merely wanted to thank you once again for the amazing blog you have built here. It can be full of useful tips for those who are really interested in this subject, particularly this very post. You really are all so sweet and also thoughtful of others plus reading your blog posts is a superb delight to me. And that of a generous surprise! Jeff and I really have enjoyment making use of your tips in what we should do in a few weeks. Our collection of ideas is a kilometer long which means your tips might be put to great use.

  34. 응답

    Hello, this weekend is nice for me, because this point in time i
    am reading this fantastic informative article here at my home.

  35. 응답

    obviously like your web site however you have to check the spelling on quite a few of your posts. Several of them are rife with spelling problems and I find it very troublesome to inform the truth however I’ll surely come again again.

  36. 응답

    Thanks for your marvelous posting! I seriously enjoyed reading it, you are a great author.
    I will make certain to bookmark your blog and will eventually
    come back later in life. I want to encourage that
    you continue your great writing, have a nice evening!

  37. 응답

    Howdy! Quick question that’s completely off topic. Do you know how to make your site mobile friendly?
    My weblog looks weird when browsing from my iphone.

    I’m trying to find a theme or plugin that might be able to resolve this issue.
    If you have any suggestions, please share. Appreciate it!

  38. 응답

    What i do not understood is in fact how you are no longer really much more neatly-preferred than you might be right now. You’re so intelligent. You understand therefore considerably in relation to this matter, made me personally believe it from a lot of varied angles. Its like women and men are not fascinated until it is something to do with Girl gaga! Your own stuffs outstanding. At all times deal with it up!

  39. 응답

    Greetings! I know this is kinda off topic but I’d figured I’d ask.
    Would you be interested in trading links or maybe
    guest authoring a blog article or vice-versa?
    My website discusses a lot of the same topics as yours and I think we
    could greatly benefit from each other. If you’re interested feel free to shoot me an email.
    I look forward to hearing from you! Wonderful blog by the
    way!

  40. 응답

    Hello there, You’ve done a great job. I’ll definitely digg it and in my opinion recommend to my friends. I am sure they’ll be benefited from this website.

  41. 응답

    Today, I went to the beachfront with my children.
    I found a sea shell and gave it to my 4 year old daughter and
    said “You can hear the ocean if you put this to your ear.” She put the shell to her ear and screamed.

    There was a hermit crab inside and it pinched her ear.
    She never wants to go back! LoL I know this is totally off topic but I had to
    tell someone!

  42. 응답

    Thank you a lot for sharing this with all folks you actually know what you are speaking about! Bookmarked. Please additionally discuss with my web site =). We could have a link change arrangement between us!

Leave a comment

이메일 주소는 공개되지 않습니다.