{"id":1371,"date":"2003-10-24T16:54:03","date_gmt":"2003-10-24T16:54:03","guid":{"rendered":"http:\/\/bluesoul.pe.kr\/wp\/?p=1371"},"modified":"2003-10-24T16:54:03","modified_gmt":"2003-10-24T16:54:03","slug":"aspmssql-asp%ec%97%90%ec%84%9c-%ed%8a%b8%eb%9e%9c%ec%a0%9d%ec%85%98%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/bluesoul.pe.kr\/wp\/?p=1371","title":{"rendered":"[asp+mssql] asp\uc5d0\uc11c \ud2b8\ub79c\uc81d\uc158\ud558\uae30"},"content":{"rendered":"

\uc608\uc804\uc5d0 \uc62c\ub9b0\uc904 \uc54c\uc558\ub294\ub370.. \ucc3e\uc544\ubcf4\ub2c8 \uc5c6\uad70\uc5ec.
\n\uc544\uc2e4\uc218\ub3c4 \uc788\uc9c0\ub9cc \uacf5\uc720\ub97c \uc704\ud558\uc57c..<\/p>\n

\uc804\uc81c\uc870\uac74\uc740 sql\uc11c\ubc84\uc5d0\uc11c distributed Transaction coordinator\uac00 \uc2dc\uc791\uc911\uc774\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/p>\n

\uc81c\uac00 \ud14c\uc2a4\ud2b8\ud560\ub54c\ub294 update\ub97c 50\uac1c \uac78\ub54c\ub294 \uc624\ub958\uac00 \uc880 \ubc1c\uc0dd\ud558\ub294 \uac70 \uac19\uc2b4\ub2e4.
\n10\uac1c \uc774\ud558\uba74 \ucda9\ubd84\ud788 \ucee4\ubc84\ud560\uc218 \uc788\uc744\ub4ef..<\/p>\n

‘\ud2b8\ub80c\uc81d\uc158 \uc2dc\uc791
\nOn Error Resume Next
\ndbcon.BeginTrans<\/p>\n

sql = “\uc6d0\ud558\ub294 sql\ubb38”
\nset rs = dbcon.execute(sql)
\nErrorNum = ErrorNum + dbcon.Errors.Count
\nset rs = nothing<\/p>\n

sql = “\uc6d0\ud558\ub294 sql\ubb38”
\nset rs = dbcon.execute(sql)
\nErrorNum = ErrorNum + dbcon.Errors.Count
\nset rs = nothing<\/p>\n

if ErrorNum = 0 then
\n DbCon.CommitTrans
\nelse
\n DbCon.RollbackTrans
\nend if<\/p>\n","protected":false},"excerpt":{"rendered":"

\uc608\uc804\uc5d0 \uc62c\ub9b0\uc904 \uc54c\uc558\ub294\ub370.. \ucc3e\uc544\ubcf4\ub2c8 \uc5c6\uad70\uc5ec. \uc544\uc2e4\uc218\ub3c4 \uc788\uc9c0\ub9cc \uacf5\uc720\ub97c \uc704\ud558\uc57c.. \uc804\uc81c\uc870\uac74\uc740 sql\uc11c\ubc84\uc5d0\uc11c distributed Transaction coordinator\uac00 \uc2dc\uc791\uc911\uc774\uc5b4\uc57c \ud569\ub2c8\ub2e4. \uc81c\uac00 \ud14c\uc2a4\ud2b8\ud560\ub54c\ub294 update\ub97c 50\uac1c \uac78\ub54c\ub294 \uc624\ub958\uac00 \uc880 \ubc1c\uc0dd\ud558\ub294 \uac70 \uac19\uc2b4\ub2e4. 10\uac1c \uc774\ud558\uba74 \ucda9\ubd84\ud788 \ucee4\ubc84\ud560\uc218 \uc788\uc744\ub4ef.. ‘\ud2b8\ub80c\uc81d\uc158 \uc2dc\uc791 On Error Resume Next dbcon.BeginTrans sql = “\uc6d0\ud558\ub294 sql\ubb38” set rs = dbcon.execute(sql) ErrorNum = ErrorNum + dbcon.Errors.Count set rs = nothing … \uacc4\uc18d \uc77d\uae30 “[asp+mssql] asp\uc5d0\uc11c \ud2b8\ub79c\uc81d\uc158\ud558\uae30”<\/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-1371","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\/1371","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=1371"}],"version-history":[{"count":0,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1371\/revisions"}],"wp:attachment":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1371"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1371"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1371"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}