\uc694\uac74 \ud2b8\ub79c\uc7ad\uc158\uc5d0 \ubb38\uc81c\uac00 \uc0dd\uae30\uba74 waiting \ud558\uac70\ub098 rollback\ub418\ub294\ub370.
\n\uace0\uac78 \uac70\uce58\uc9c0 \uc54a\uace0 \ubb38\uc81c\uac00 \uc788\ub354\ub77c\ub3c4 \uace0\ub0e5 \uc77d\uc5b4\ubc84\ub9b0\ub2e4.
\n\uc5c5\ub370\uc774\ud2b8\ub098 writing\uc774 \ubb34\uc9c0 \ubc14\uc05c\uacf3\uc5d0\ub9cc \uc4f0\ub3c4\ub85d \ud558\uc790<\/p>\n
\uc544\uc6b8\ub7ec \ub9ac\uc2a4\ud2b8 \ud398\uc774\uc9c0\uc5d0\uc11c \ud544\uc694\ud55c \ub370\uc774\ud130\ub9cc select \ud560\uc218 \uc788\ub294 sql\ubb38\uc774\ub2e4.
\n\ubc14\ub85c\uc804\uc5d0 \uc62c\ub838\ub358\uac70\ub791 \ucabc\ub054 \ud2c0\ub9b0\ub370 \ucc28\uc774\uc810\uc744 \ube44\uad50\ud574 \ubcf4\uae30 \ubc14\ub780\ub2e4.
\n\uc544\ub798 \ubb38\uc7a5\uc774 \ucabc\ub054 \ub354 \ube60\ub974\ub2e4\uace0 \ud55c\ub2e4. <\/p>\n
set transaction isolation level read uncommitted
\nSelect Top [\uc6d0\ud558\ub294 \ub808\ucf54\ub4dc\uc218] a.*,b.writername,b.wlevel,b.mflag
\nFrom [\ud14c\uc774\ube14\uba85] a
\nLeft Outer Join Writer_Status b On a.id=b.memberid
\nWhere a.Idx In
\n\t(
\n\tSelect top [\uc6d0\ud558\ub294\ub808\ucf54\ub4dc\uc218] idx
\n\tFrom
\n\t\t(Select Top [\ub118\uc5b4\uc628\ud398\uc774\uc9c0*\uc6d0\ud558\ub294\ub808\ucf54\ub4dc\uc218] idx,ref,stp,recommand,sorting,rcnt
\n\t\tFrom [\ud14c\uc774\ube14\uba85]
\n\t\tOrder By ref desc, stp asc ) a
\n\tOrder By ref asc, stp desc
\n\t)
\norder By a.ref desc, stp asc <\/p>\n","protected":false},"excerpt":{"rendered":"
\uc694\uac74 \ud2b8\ub79c\uc7ad\uc158\uc5d0 \ubb38\uc81c\uac00 \uc0dd\uae30\uba74 waiting \ud558\uac70\ub098 rollback\ub418\ub294\ub370. \uace0\uac78 \uac70\uce58\uc9c0 \uc54a\uace0 \ubb38\uc81c\uac00 \uc788\ub354\ub77c\ub3c4 \uace0\ub0e5 \uc77d\uc5b4\ubc84\ub9b0\ub2e4. \uc5c5\ub370\uc774\ud2b8\ub098 writing\uc774 \ubb34\uc9c0 \ubc14\uc05c\uacf3\uc5d0\ub9cc \uc4f0\ub3c4\ub85d \ud558\uc790 \uc544\uc6b8\ub7ec \ub9ac\uc2a4\ud2b8 \ud398\uc774\uc9c0\uc5d0\uc11c \ud544\uc694\ud55c \ub370\uc774\ud130\ub9cc select \ud560\uc218 \uc788\ub294 sql\ubb38\uc774\ub2e4. \ubc14\ub85c\uc804\uc5d0 \uc62c\ub838\ub358\uac70\ub791 \ucabc\ub054 \ud2c0\ub9b0\ub370 \ucc28\uc774\uc810\uc744 \ube44\uad50\ud574 \ubcf4\uae30 \ubc14\ub780\ub2e4. \uc544\ub798 \ubb38\uc7a5\uc774 \ucabc\ub054 \ub354 \ube60\ub974\ub2e4\uace0 \ud55c\ub2e4. set transaction isolation level read uncommitted Select Top [\uc6d0\ud558\ub294 \ub808\ucf54\ub4dc\uc218] a.*,b.writername,b.wlevel,b.mflag From … \uacc4\uc18d \uc77d\uae30 “[MSSQL] \ud2b8\ub79c\uc7ad\uc158 \uace0\ub9bd\uc218\uc900\uc744 \ubcc0\uacbd\ud558\uace0 \uc2f6\uc744\ub54c”<\/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-1407","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\/1407","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=1407"}],"version-history":[{"count":0,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1407\/revisions"}],"wp:attachment":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1407"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1407"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1407"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}