{"id":5854,"date":"2014-07-31T06:00:21","date_gmt":"2014-07-30T21:00:21","guid":{"rendered":"http:\/\/fujiitoshiki.com\/improvesociety\/?p=5854"},"modified":"2019-03-15T11:56:07","modified_gmt":"2019-03-15T02:56:07","slug":"post-5854","status":"publish","type":"post","link":"https:\/\/www.fujiitoshiki.com\/improvesociety\/?p=5854","title":{"rendered":"SQL Server\u306e\u30b9\u30ab\u30e9\u30fc\u5024\u95a2\u6570\u3068\u3057\u3066nPNA\u3092\u5b9a\u7fa9\u3059\u308b\u306b\u306f"},"content":{"rendered":"<div class=\"theContentWrap-ccc\"><p>\u3000\u305f\u3093\u3071\u304f\u8cea\u6442\u53d6\u91cf\u306e\u6307\u6a19\u3068\u3057\u3066\u65e5\u672c\u900f\u6790\u533b\u5b66\u4f1a\u3067\u306f PCR \u3092\u63a1\u7528\u3057\u3066\u3044\u307e\u3059\uff0e\u4e00\u65b9 K\/DOQQI \u3067\u306f nPNA \u3092\u63a1\u7528\u3057\u3066\u3044\u307e\u3059\uff0eDaugirdas \u306e\u65b9\u6cd5\u3067 Kt\/V \u3092\u8a08\u7b97\u3059\u308b\u3068 nPNA \u3082\u8a08\u7b97\u3067\u304d\u307e\u3059\uff0e<\/p>\n<p><img src='https:\/\/s0.wp.com\/latex.php?latex=%5Cdisplaystyle+%5Cmathrm%7BnPNA%7D+%3D+%5Cfrac%7BC_0%7D%7B36.3+%2B+5.48%5Ctimes%5Cmathrm%7BKt%2FV%7D+%2B+53.5%2F%5Cmathrm%7BKt%2FV%7D%7D+%2B+0.168+%5C%5C++%3D+%5Cfrac%7B%5Cmathrm%7BpreBUN%7D%7D%7B36.3+%2B+5.48%5Ctimes%5Cmathrm%7BKt%2FV%7D+%2B+53.5+%2F+%5Cmathrm%7BKt%2FV%7D%7D+%2B+0.168+%5Ccdots%284%29&#038;bg=T&#038;fg=000000&#038;s=0' alt='\\displaystyle \\mathrm{nPNA} = \\frac{C_0}{36.3 + 5.48\\times\\mathrm{Kt\/V} + 53.5\/\\mathrm{Kt\/V}} + 0.168 \\\\  = \\frac{\\mathrm{preBUN}}{36.3 + 5.48\\times\\mathrm{Kt\/V} + 53.5 \/ \\mathrm{Kt\/V}} + 0.168 \\cdots(4)' title='\\displaystyle \\mathrm{nPNA} = \\frac{C_0}{36.3 + 5.48\\times\\mathrm{Kt\/V} + 53.5\/\\mathrm{Kt\/V}} + 0.168 \\\\  = \\frac{\\mathrm{preBUN}}{36.3 + 5.48\\times\\mathrm{Kt\/V} + 53.5 \/ \\mathrm{Kt\/V}} + 0.168 \\cdots(4)' class='latex' \/><\/p>\n<p>\u3000\u4e0b\u8a18\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3092\u5b9f\u884c\u3057\u3066\u95a2\u6570\u3092\u4f5c\u6210\u3057\u307e\u3059\uff0e<\/p>\n<pre>\r\nCREATE FUNCTION Function_nPNA \r\n(\t\t@preBUN\t\tDEC(4, 1)\r\n\t,\t@postBUN\tDEC(4, 1)\r\n\t,\t@preWeight\tDEC(4, 1)\r\n\t,\t@postWeight\tDEC(4, 1)\r\n\t,\t@DialysisDuration\tint\r\n)\r\nRETURNS DEC(3, 2)\r\nAS\r\nBEGIN\r\n\tDECLARE @nPNA\tDEC(3, 2)\r\n\tSELECT\t@nPNA = @preBUN\r\n\t\/\t(36.3 + 5.48 * (dbo.Function_KtV(@preBUN, @postBUN, @preWeight, @postWeight, @DialysisDuration))\r\n\t+\t\t\t53.5 \/ (dbo.Function_KtV(@preBUN, @postBUN, @preWeight, @postWeight, @DialysisDuration)))\r\n\t+\t0.168\r\n\tRETURN\t@nPNA\r\nEND\r\n<\/pre>\n<p>\u53c2\u7167\uff1a<a href=\"\/\/fujiitoshiki.com\/improvesociety\/?p=82\" target=\"_blank\" rel=\"noopener noreferrer\">\u7dad\u6301\u900f\u6790\u60a3\u8005\u306e\u305f\u3081\u306e\u7c21\u6613\u6804\u990a\u30b9\u30af\u30ea\u30fc\u30cb\u30f3\u30b0\u30c4\u30fc\u30eb<\/a><\/p>\n<p><iframe src=\"\/\/rcm-fe.amazon-adsystem.com\/e\/cm?lt1=_blank&#038;bc1=000000&#038;IS2=1&#038;bg1=FFFFFF&#038;fc1=000000&#038;lc1=0000FF&#038;t=fujiitoshiki-22&#038;o=9&#038;p=8&#038;l=as4&#038;m=amazon&#038;f=ifr&#038;ref=ss_til&#038;asins=4798128023\" style=\"width:120px;height:240px;\" scrolling=\"no\" marginwidth=\"0\" marginheight=\"0\" frameborder=\"0\"><\/iframe><iframe src=\"\/\/rcm-fe.amazon-adsystem.com\/e\/cm?lt1=_blank&#038;bc1=000000&#038;IS2=1&#038;bg1=FFFFFF&#038;fc1=000000&#038;lc1=0000FF&#038;t=fujiitoshiki-22&#038;o=9&#038;p=8&#038;l=as4&#038;m=amazon&#038;f=ifr&#038;ref=ss_til&#038;asins=B00JRW7K4Q\" style=\"width:120px;height:240px;\" scrolling=\"no\" marginwidth=\"0\" marginheight=\"0\" frameborder=\"0\"><\/iframe><iframe src=\"\/\/rcm-fe.amazon-adsystem.com\/e\/cm?lt1=_blank&#038;bc1=000000&#038;IS2=1&#038;bg1=FFFFFF&#038;fc1=000000&#038;lc1=0000FF&#038;t=fujiitoshiki-22&#038;o=9&#038;p=8&#038;l=as4&#038;m=amazon&#038;f=ifr&#038;ref=ss_til&#038;asins=4885632110\" style=\"width:120px;height:240px;\" scrolling=\"no\" marginwidth=\"0\" marginheight=\"0\" frameborder=\"0\"><\/iframe><\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>\u3000\u305f\u3093\u3071\u304f\u8cea\u6442\u53d6\u91cf\u306e\u6307\u6a19\u3068\u3057\u3066\u65e5\u672c\u900f\u6790\u533b\u5b66\u4f1a\u3067\u306f PCR \u3092\u63a1\u7528\u3057\u3066\u3044\u307e\u3059\uff0e\u4e00\u65b9 K\/DOQQI \u3067\u306f nPNA \u3092\u63a1\u7528\u3057\u3066\u3044\u307e\u3059\uff0eDaugirdas \u306e\u65b9\u6cd5\u3067 Kt\/V \u3092\u8a08\u7b97\u3059\u308b\u3068 nPNA \u3082\u8a08\u7b97\u3067\u304d\u307e\u3059\uff0e \u3000\u4e0b\u8a18 &hellip; <a href=\"https:\/\/www.fujiitoshiki.com\/improvesociety\/?p=5854\" class=\"more-link\"><span class=\"screen-reader-text\">&#8220;SQL Server\u306e\u30b9\u30ab\u30e9\u30fc\u5024\u95a2\u6570\u3068\u3057\u3066nPNA\u3092\u5b9a\u7fa9\u3059\u308b\u306b\u306f&#8221; \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":6024,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[1,11,4],"tags":[134,130,135,132,136,138,140,139],"class_list":["post-5854","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database","category-healthcare","category-nutrition","tag-daugirdas","tag-kdoqqi","tag-ktv","tag-npna","tag-sql-server","tag-138","tag-140","tag-139"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.fujiitoshiki.com\/improvesociety\/index.php?rest_route=\/wp\/v2\/posts\/5854","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fujiitoshiki.com\/improvesociety\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fujiitoshiki.com\/improvesociety\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fujiitoshiki.com\/improvesociety\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fujiitoshiki.com\/improvesociety\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5854"}],"version-history":[{"count":12,"href":"https:\/\/www.fujiitoshiki.com\/improvesociety\/index.php?rest_route=\/wp\/v2\/posts\/5854\/revisions"}],"predecessor-version":[{"id":7970,"href":"https:\/\/www.fujiitoshiki.com\/improvesociety\/index.php?rest_route=\/wp\/v2\/posts\/5854\/revisions\/7970"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fujiitoshiki.com\/improvesociety\/index.php?rest_route=\/wp\/v2\/media\/6024"}],"wp:attachment":[{"href":"https:\/\/www.fujiitoshiki.com\/improvesociety\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5854"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fujiitoshiki.com\/improvesociety\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5854"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fujiitoshiki.com\/improvesociety\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5854"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}