{"id":15405,"date":"2022-08-18T06:00:00","date_gmt":"2022-08-17T21:00:00","guid":{"rendered":"https:\/\/www.muscle-hypertrophy.com\/?p=15405"},"modified":"2022-07-18T08:31:59","modified_gmt":"2022-07-17T23:31:59","slug":"%e9%9a%8e%e4%b9%97%e3%81%ae%e8%87%aa%e7%84%b6%e5%af%be%e6%95%b0%e3%82%92%e6%b1%82%e3%82%81%e3%82%8b%e3%83%a6%e3%83%bc%e3%82%b6%e3%83%bc%e5%ae%9a%e7%be%a9%e9%96%a2%e6%95%b0%e3%82%92sql-server%e3%81%a7","status":"publish","type":"post","link":"https:\/\/www.muscle-hypertrophy.com\/?p=15405","title":{"rendered":"\u968e\u4e57\u306e\u81ea\u7136\u5bfe\u6570\u3092\u6c42\u3081\u308b\u30e6\u30fc\u30b6\u30fc\u5b9a\u7fa9\u306e\u30b9\u30ab\u30e9\u30fc\u5024\u95a2\u6570\u3092SQL Server\u3067\u5b9a\u7fa9\u3059\u308b"},"content":{"rendered":"\n<p>\u3000Fisher\u306e\u76f4\u63a5\u78ba\u7387\u3092\u6c42\u3081\u308b\u969b\uff0c\u968e\u4e57\u306e\u8a08\u7b97\u304c\u5fc5\u8981\u306b\u306a\u308b\uff0e\u3057\u304b\u3057\uff0c\u5f15\u6570\u304c\u6700\u5927\u3067\u3082170\u307e\u3067\u3068\u4f7f\u3044\u52dd\u624b\u304c\u826f\u304f\u306a\u3044\uff0e\u3053\u308c\u306f\u30d7\u30ed\u30b0\u30e9\u30e0\u8a00\u8a9e\u306e\u7a2e\u985e\u306b\u304b\u304b\u308f\u3089\u305a\uff0c\u30c7\u30fc\u30bf\u9577\u306e\u5236\u7d04\u304c\u539f\u56e0\u3067\u3042\u308b\uff0e\u4eca\u56de\u306f\u5bfe\u6570\u3092\u7528\u3044\u3066\u968e\u4e57\u8a08\u7b97\u306e\u5f15\u6570\u306e\u9650\u754c\u3092\u8d85\u3048\u308b\u30a2\u30a4\u30c7\u30a2\u3092\u5171\u6709\u3057\u305f\u3044\uff0e<\/p>\n<p><!--more--><\/p>\n<h2>\u5bfe\u6570\u306e\u6307\u6570\u306f\u5143\u306e\u5024<\/h2>\n<p>\u3000N \u3092\u4efb\u610f\u306e\u81ea\u7136\u6570\u3068\u3059\u308b\u3068\u304d\uff0cExp(LN(N!)) = N! \u306f\u81ea\u660e\u3067\u3042\u308b\uff0e\u4eca\u56de\u306f\u3053\u306e\u6307\u6570\u95a2\u6570\u306e\u5f15\u6570\u3067\u3042\u308b LN(N!) \u3092\u6c42\u3081\u305f\u3044\uff0eExp() \u306f\u81ea\u7136\u5bfe\u6570\u3092\u5e95\u3068\u3059\u308b\u6307\u6570\u95a2\u6570\uff0cLN() \u306f\u81ea\u7136\u5bfe\u6570\u3092\u5e95\u3068\u3059\u308b\u5bfe\u6570\u95a2\u6570\u3067\u3042\u308b\u3068\u3059\u308b\uff0e<\/p>\n<p>\u3000N! = N * (N &#8211; 1) * &#8230; * 1 \u3067\u3042\u308b\u304b\u3089\uff0cLN(N!) = LN(N) + LN(N &#8211; 1) + &#8230; + LN(1) \u3068\u306a\u308b\uff0e\u3053\u308c\u3092\u30b3\u30fc\u30c9\u306b\u5b9f\u88c5\u3059\u308b\uff0e<\/p>\n<h2>\u30e6\u30fc\u30b6\u30fc\u5b9a\u7fa9\u306e\u30b9\u30ab\u30e9\u30fc\u5024\u95a2\u6570<\/h2>\n<p>\u3000SQL Server \u306e\u30af\u30a8\u30ea\u30a6\u30a3\u30f3\u30c9\u30a6\u3067\u4e0b\u8a18\u30b3\u30fc\u30c9\u3092\u5b9f\u884c\u3059\u308b\uff0e\u5f97\u3089\u308c\u305f\u7d50\u679c\u306f\u30b9\u30ab\u30e9\u30fc\u5024\u3067\u3042\u308b\u305f\u3081\uff0c\u4e0b\u56f3\u306e\u3088\u3046\u306b\u300c\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u300d\u304b\u3089\u300c\u95a2\u6570\u300d\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u300c\u65b0\u898f\u4f5c\u6210\u300d\u300c\u30b9\u30ab\u30e9\u30fc\u5024\u95a2\u6570&#8230;\u300d\u3068\u9032\u3080\uff0e<\/p>\n<figure id=\"attachment_15419\" aria-describedby=\"caption-attachment-15419\" style=\"width: 493px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/00-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-15419\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/00-1.png\" alt=\"\u300c\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u300d\u300c\u95a2\u6570\u300d\u300c\u65b0\u898f\u4f5c\u6210\u300d\u300c\u30b9\u30ab\u30e9\u30fc\u5024\u95a2\u6570...\u300d\" width=\"493\" height=\"275\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/00-1.png 493w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2022\/07\/00-1-300x167.png 300w\" sizes=\"auto, (max-width: 493px) 100vw, 493px\" \/><\/a><figcaption id=\"caption-attachment-15419\" class=\"wp-caption-text\">\u300c\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u300d\u300c\u95a2\u6570\u300d\u300c\u65b0\u898f\u4f5c\u6210\u300d\u300c\u30b9\u30ab\u30e9\u30fc\u5024\u95a2\u6570&#8230;\u300d<\/figcaption><\/figure>\n<p>\u3000\u5b9f\u969b\u306e\u30b3\u30fc\u30c9\u306f\u4e0b\u8a18\u306e\u3068\u304a\u308a\u3067\u3042\u308b\uff0e<\/p>\n<ul>\n<li>1\u884c\u76ee CREATE FUNCTION \u3067\u95a2\u6570\u540d\u3092\u5b9a\u7fa9\u3059\u308b<\/li>\n<li>3\u884c\u76ee\uff0c\u95a2\u6570\u540d\u306e\u6b21\u306e ( ) \u5185\u3067\u5f15\u6570\u3068\u305d\u306e\u30c7\u30fc\u30bf\u578b\u3092\u5b9a\u7fa9\u3059\u308b<\/li>\n<li>5\u884c\u76ee RETURNS \u3067\u623b\u308a\u5024\u306e\u30c7\u30fc\u30bf\u578b\u3092\u5b9a\u7fa9\u3059\u308b<\/li>\n<li>7\u884c\u76ee\u4ee5\u964d BEGIN \u304b\u3089 END \u307e\u3067\u3067\u95a2\u6570\u306e\u5185\u5bb9\u3092\u5b9a\u7fa9\u3059\u308b<\/li>\n<li>15\u884c\u76ee RETURN \u3067\u95a2\u6570\u306b\u623b\u308a\u5024\u3092\u4ee3\u5165\u3059\u308b<\/li>\n<\/ul>\n<pre>CREATE FUNCTION LOG_FACT\n(\n\t@SrcNumber INT\n)\nRETURNS FLOAT\nAS\nBEGIN\n\tDECLARE @DesNumber FLOAT\n\tSET @DesNumber = LOG(1)\n\tWHILE @SrcNumber &gt; 0\n\tBEGIN\n\t\tSET @DesNumber = @DesNumber + LOG(@SrcNumber)\n\t\tSET @SrcNumber = @SrcNumber - 1\n\tEND\n\tRETURN @DesNumber\nEND\nGO\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u3000Fisher\u306e\u76f4\u63a5\u78ba\u7387\u3092\u6c42\u3081\u308b\u969b\uff0c\u968e\u4e57\u306e\u8a08\u7b97\u304c\u5fc5\u8981\u306b\u306a\u308b\uff0e\u3057\u304b\u3057\uff0c\u5f15\u6570\u304c\u6700\u5927\u3067\u3082170\u307e\u3067\u3068\u4f7f\u3044\u52dd\u624b\u304c\u826f\u304f\u306a\u3044\uff0e\u3053\u308c\u306f\u30d7\u30ed\u30b0\u30e9\u30e0\u8a00\u8a9e\u306e\u7a2e\u985e\u306b\u304b\u304b\u308f\u3089\u305a\uff0c\u30c7\u30fc\u30bf\u9577\u306e\u5236\u7d04\u304c\u539f\u56e0\u3067\u3042\u308b\uff0e\u4eca\u56de\u306f\u5bfe\u6570\u3092\u7528\u3044\u3066\u968e\u4e57\u8a08\u7b97\u306e\u5f15\u6570\u306e\u9650\u754c &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/?p=15405\" class=\"more-link\"><span class=\"screen-reader-text\">&#8220;\u968e\u4e57\u306e\u81ea\u7136\u5bfe\u6570\u3092\u6c42\u3081\u308b\u30e6\u30fc\u30b6\u30fc\u5b9a\u7fa9\u306e\u30b9\u30ab\u30e9\u30fc\u5024\u95a2\u6570\u3092SQL Server\u3067\u5b9a\u7fa9\u3059\u308b&#8221; \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":15391,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[11866,11223,11882,7752,3562,11871,11884,11937,651,11872,11885,3962,11881,11883,2740,2872,7455,11877,3574,3600,4555,11867,11876,4354,11874,11873,3549,8386,11869,5085,2487,661,2893,11865,11863,11870,11230,2965,684,11868],"class_list":{"0":"post-15405","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","6":"hentry","7":"category-technology","8":"tag-11866","9":"tag-begin","10":"tag-create-function","11":"tag-declare","12":"tag-end","13":"tag-exp","14":"tag-exp-2","15":"tag-fisher","17":"tag-ln","18":"tag-ln-2","19":"tag-log","20":"tag-n-2","21":"tag-returns","22":"tag-sql-server","23":"tag-t-sql","24":"tag-7455","25":"tag-11877","26":"tag-3574","27":"tag-3600","28":"tag-4555","29":"tag-11867","30":"tag-11876","31":"tag-4354","32":"tag-11874","33":"tag-11873","34":"tag-3549","35":"tag-8386","36":"tag-11869","37":"tag-5085","38":"tag-2487","39":"tag-661","40":"tag-2893","41":"tag-11865","42":"tag-11863","43":"tag-11870","44":"tag-11230","45":"tag-2965","46":"tag-684","47":"tag-11868"},"_links":{"self":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/15405","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=15405"}],"version-history":[{"count":18,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/15405\/revisions"}],"predecessor-version":[{"id":15568,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/15405\/revisions\/15568"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/media\/15391"}],"wp:attachment":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=15405"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=15405"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=15405"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}