{"id":1409,"date":"2004-05-07T12:01:40","date_gmt":"2004-05-07T12:01:40","guid":{"rendered":"http:\/\/bluesoul.pe.kr\/wp\/?p=1409"},"modified":"2004-05-07T12:01:40","modified_gmt":"2004-05-07T12:01:40","slug":"mssql-%ec%83%81%ea%b4%80-%eb%b6%80%ec%a7%88%ec%9d%98%eb%a5%bc-%ec%9d%b4%ec%9a%a9%ed%95%9c-%ec%97%85%eb%8d%b0%ec%9d%b4%ed%8a%b8-%eb%ac%b8","status":"publish","type":"post","link":"https:\/\/bluesoul.pe.kr\/wp\/?p=1409","title":{"rendered":"[mssql] \uc0c1\uad00 \ubd80\uc9c8\uc758\ub97c \uc774\uc6a9\ud55c \uc5c5\ub370\uc774\ud2b8 \ubb38"},"content":{"rendered":"

\ubd80\uc9c8\uc758\ub294 sql\ubb38\uc548\uc5d0 \ub610\ud558\ub098\uc758 sql\ubb38\uc774 \uc788\ub2e4\ub294\uac78 \ub9d0\ud55c\ub2e4.
\n\uc0c1\uad00 \ubd80\uc9c8\uc758\ub294 \uadf8 \ub610 \ud558\ub098\uc758 sql\ubb38\uc774 \uadf8 \uc790\uccb4\ub85c \uc2e4\ud589\ub418\uba74 \uc5d0\ub7ec\uac00 \ub098\ub294 \uacbd\uc6b0\ub97c \ub9d0\ud55c\ub2e4.
\n\uc5c5\ub370\uc774\ud2b8 \ub418\ub294 \ud544\ub4dc\uc5d0\ub294 \uc5ec\ub7ec\uac12\uc774 \ub4e4\uc5b4\uac08\uc218 \uc5c6\ub2e4.<\/p>\n

\uc704\uc758 \uc870\uac74\ub4e4\uc744 \uc5fc\ub450\uc5d0 \ub450\uace0 \ub2e4\uc74c\uc758 \uacbd\uc6b0\ub97c \uc0dd\uac01\ud574\ubcf4\uc790.
\ntitles \ud14c\uc774\ube14\uc5d0\uc11c ytd_sales \ub77c\ub294 \uc5f0\uac04 \ucd1d\ud310\ub9e4\ub7c9\uc744 \uc785\ub825\ud558\ub294 \uceec\ub7fc\uc774 \uc788\ub2e4.
\n\uc774 \uce7c\ub7fc\uc5d0 94\ub144\uc5d0 \ud310\ub9e4\ub41c \ubaa8\ub4e0 \uc218\ub7c9\uc744 \uc5c5\ub370\uc774\ud2b8 \ud558\uace0 \uc2f6\uc73c\uba74
\n\uc544\ub798\uc640 \uac19\uc774 \uc0dd\uac01\ud560\uc218 \uc788\ub2e4.<\/p>\n

update titles
\nset ytd_sales = ytd_sales + (
\n select qty
\n from sales
\n where sales.title_id = titles.title_id
\n and ord_date between ‘1\/1\/94′ and ’12\/31\/94’
\n)<\/p>\n

\uadf8\ub7ec\ub098 \uc704\uc640 \uac19\uc774 \ud558\uba74 \uc5d0\ub7ec\uac00 \ub09c\ub2e4. \uc774\uc720\ub294 \uc5c5\ub370\uc774\ud2b8\ub420 \ud544\ub4dc\ub294 \uc5ec\ub7ec\uac12\uc774 \ub4e4\uc5b4 \uac08\uc218 \uc5c6\uae30 \ub54c\ubb38\uc774\ub2e4.
\n\uadf8\ub7ec\uba74 \uc5b4\ub5bb\uac8c \ud574\uc57c \ud558\ub098<\/p>\n

update titles
\nset ytd_sales = (
\n select sum(qty)
\n from sales
\n where sales.title_id = titles.title_id
\n and ord_date between ‘1\/1\/94′ and ’12\/31\/94’
\n)<\/p>\n

\uc774\ub807\uac8c \ud558\uba74 \ud574\ub2f9\ud558\ub294 \uc81c\ubaa9\uc5d0 \ub300\ud55c sales\ud14c\uc774\ube14\uc758 \uc218\ub7c9\uc744 \ubaa8\ub450 \ub354\ud558\uac00 \uadf8 \ub354\ud55c\uac12\uc744 \ud55c\ubc88\ub9cc \ud574\ub2f9\ud558\ub294 titles\uc758 \ud574\ub2f9\ud589\uc5d0 \ub354\ud558\ubbc0\ub85c \ud55c\ud589\uc5d0 \ub300\ud574\uc11c\ub294 \ud55c\ubc88\ub9cc update\uac00 \ub418\ub294 \uac83\uc774\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"

\ubd80\uc9c8\uc758\ub294 sql\ubb38\uc548\uc5d0 \ub610\ud558\ub098\uc758 sql\ubb38\uc774 \uc788\ub2e4\ub294\uac78 \ub9d0\ud55c\ub2e4. \uc0c1\uad00 \ubd80\uc9c8\uc758\ub294 \uadf8 \ub610 \ud558\ub098\uc758 sql\ubb38\uc774 \uadf8 \uc790\uccb4\ub85c \uc2e4\ud589\ub418\uba74 \uc5d0\ub7ec\uac00 \ub098\ub294 \uacbd\uc6b0\ub97c \ub9d0\ud55c\ub2e4. \uc5c5\ub370\uc774\ud2b8 \ub418\ub294 \ud544\ub4dc\uc5d0\ub294 \uc5ec\ub7ec\uac12\uc774 \ub4e4\uc5b4\uac08\uc218 \uc5c6\ub2e4. \uc704\uc758 \uc870\uac74\ub4e4\uc744 \uc5fc\ub450\uc5d0 \ub450\uace0 \ub2e4\uc74c\uc758 \uacbd\uc6b0\ub97c \uc0dd\uac01\ud574\ubcf4\uc790. titles \ud14c\uc774\ube14\uc5d0\uc11c ytd_sales \ub77c\ub294 \uc5f0\uac04 \ucd1d\ud310\ub9e4\ub7c9\uc744 \uc785\ub825\ud558\ub294 \uceec\ub7fc\uc774 \uc788\ub2e4. \uc774 \uce7c\ub7fc\uc5d0 94\ub144\uc5d0 \ud310\ub9e4\ub41c \ubaa8\ub4e0 \uc218\ub7c9\uc744 \uc5c5\ub370\uc774\ud2b8 \ud558\uace0 \uc2f6\uc73c\uba74 \uc544\ub798\uc640 \uac19\uc774 \uc0dd\uac01\ud560\uc218 \uc788\ub2e4. update … \uacc4\uc18d \uc77d\uae30 “[mssql] \uc0c1\uad00 \ubd80\uc9c8\uc758\ub97c \uc774\uc6a9\ud55c \uc5c5\ub370\uc774\ud2b8 \ubb38”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1409","post","type-post","status-publish","format-standard","hentry","category-tip"],"_links":{"self":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1409","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1409"}],"version-history":[{"count":0,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1409\/revisions"}],"wp:attachment":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1409"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1409"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1409"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}