{"title":"\u6574\u6570\u5024\u30923\u6841\u30ab\u30f3\u30de\u533a\u5207\u308a\u306b\u6574\u5f62\u3059\u308b\u30e6\u30fc\u30b6\u5b9a\u7fa9\u95a2\u6570","published":"2011-06-16 00:00:00","categories":["SQLServer"],"image_url":null,"provider_name":"Hatena Blog","blog_url":"https://babydaemons.hatenablog.com/","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fbabydaemons.hatenablog.com%2Fentry%2F20110616%2FSQLServer_CommaFormatting_UserDefineFunction\" title=\"\u6574\u6570\u5024\u30923\u6841\u30ab\u30f3\u30de\u533a\u5207\u308a\u306b\u6574\u5f62\u3059\u308b\u30e6\u30fc\u30b6\u5b9a\u7fa9\u95a2\u6570 - babydaemons\u2019 blog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","author_url":"https://blog.hatena.ne.jp/babydaemons/","blog_title":"babydaemons\u2019 blog","type":"rich","url":"https://babydaemons.hatenablog.com/entry/20110616/SQLServer_CommaFormatting_UserDefineFunction","width":"100%","height":"190","description":"\u306a\u3093\u304b\u6614\u30a8\u30f3\u30c8\u30ea\u66f8\u3044\u305f\u6c17\u304c\u3059\u308b\u3093\u3060\u3051\u3069\u3001\u8efd\u304f\u691c\u7d22\u3057\u305f\u3089\u898b\u3064\u304b\u3089\u306a\u304b\u3063\u305f\u306e\u3067\u5099\u5fd8\u9332\u306b\u6b8b\u3057\u3066\u304a\u304d\u307e\u3059\u3002 \u5143\u30cd\u30bf\u306f \u3053\u3061\u3089\u3067\u3059\u2193 \u89e3\u8aac\u3082\u3053\u3061\u3089\u3067\u3059\u2193 CONVERT\u3092\u4f7f\u3044\u3053\u306a\u305d\u3046\uff01\uff01 \uff5e\u6570\u5024\u7de8\uff5e\uff5c\u30bd\u30d5\u30c8\u30a6\u30a8\u30a2\u958b\u767a\u90e8\uff08\u30b7\u30b9\u30c6\u30e0\u958b\u767a\u30fb\u30b7\u30b9\u30c6\u30e0\u8a2d\u8a08 \u682a\u5f0f\u4f1a\u793e\u30a2\u30a4\u30ed\u30d9\u30c3\u30af\u30b9\uff5c\u6771\u4eac\u90fd\u65b0\u5bbf\u533a\uff09 \u30bd\u30fc\u30b9\u3092\u6652\u3057\u3066\u304a\u304f CREATE FUNCTION [dbo].[FORMAT_COMMA](@value int) RETURNS varchar(20) AS BEGIN RETURN REPLACE(CONVERT(varchar(20), CAST(@value AS money), 1), '.00', '')\u2026","version":"1.0","provider_url":"https://hatena.blog","author_name":"babydaemons"}