{"id":1870,"date":"2011-09-02T00:24:55","date_gmt":"2011-09-02T00:24:55","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=1870"},"modified":"2011-09-02T00:24:55","modified_gmt":"2011-09-02T00:24:55","slug":"%e7%b4%a2%e5%bc%95%e9%94%ae%e5%80%bc%e5%ad%98%e5%82%a8%e7%9a%84%e4%bf%a1%e6%81%af","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2011\/09\/02\/%e7%b4%a2%e5%bc%95%e9%94%ae%e5%80%bc%e5%ad%98%e5%82%a8%e7%9a%84%e4%bf%a1%e6%81%af\/","title":{"rendered":"\u7d22\u5f15\u952e\u503c\u5b58\u50a8\u7684\u4fe1\u606f"},"content":{"rendered":"

\u805a\u96c6\u7d22\u5f15\u53f6\u7ea7\u522b\u9664\u4e86\u4fdd\u6301\u952e\u503c\u5916\uff0c\u8fd8\u5305\u542b\u6240\u6709\u6570\u636e
\n\u975e\u805a\u96c6\u7d22\u5f15\u53f6\u7ea7\u522b\u53ea\u6709\u9700\u8981\u7684\u952e\u503c\u53ca\u4e66\u7b7e\uff0c\u4ee5\u201c\u6587\u4ef6\u53f7\uff1a\u9875\u53f7\uff1a\u69fd\u53f7\u201d\u7684\u683c\u5f0f\u5b9a\u4f4d
\n\u67e5\u770b\u7d22\u5f15\u5b58\u50a8\uff1a
\n–\u6253\u5f003604\uff0c\u4fe1\u606f\u53d1\u9001\u5230\u63a7\u5236\u53f0
\nDBCC TRACEON(3604)
\n–\u67e5\u770b\u8868\u7d22\u5f15\u5bf9\u5e94\u7684\u9875\u6570\u660e\u7ec6
\nDBCC IND (‘brm_lvjian_new’, ‘frmuser’, -1);
\n–\u67e5\u770b\u9875\u4e0a\u7684\u6570\u636e\u4fe1\u606f
\nDBCC PAGE (brm_lvjian_new, 1, 586958, 1);
\n\u5728Memory Dump\u4e0b\u5b58\u50a8\u7740\u4fe1\u606f\u3002<\/p>\n

\u4e0d\u8fc7\u975e\u805a\u96c6\u7d22\u5f15\u5e76\u4e0d\u4e00\u5b9a\u6bd4\u805a\u96c6\u7d22\u5f15\u5feb\uff0c\u4f46where\u6761\u4ef6\uff0cselect\u5b57\u6bb5\u90fd\u662f\u590d\u5408\u7d22\u5f15\u5b57\u6bb5\u65f6\uff0c\u56e0\u7d22\u5f15
\n\u7a7a\u95f4\u8f83\u5c0f\uff0c\u6bd4\u4ef6\u805a\u96c6\u7d22\u5f15\u67e5\u627e\u5feb\u4e00\u4e9b\u3002
\n\u5982\uff1a\u5728frmUser\u8868\u4e2dDepartmentID\u4e0a\u5efa\u7acb\u975e\u805a\u96c6\u7d22\u5f15
\n\u6267\u884c\uff1a
\nSELECT departmentid
\nFROM frmuser
\nWHERE DepartmentId = 4<\/p>\n

SELECT *
\nFROM frmuser
\nWHERE DepartmentId = 4<\/p>\n

\u53d1\u73b0\u524d\u8005\u901a\u8fc7\u7d22\u5f15\u67e5\u627e\u4e00\u6b65\u5230\u4f4d\uff0c\u800c\u540e\u8005\u5728\u7d22\u5f15\u67e5\u627e\u540e\uff0c\u56e0\u8fd8\u8981\u53d6\u5176\u5b83\u503c\uff0c\u6545\u8fd8\u8981\u6839\u636e\u7d22\u5f15\u9875\u952e\u503c\u4e2d\u7684\u5f15\u7528\uff0c\u53bb\u6570\u636e\u9875\u53d6\u503c
\n\u8fd9\u63d0\u793a\uff1aSELECT\u4e2d\u7684\u5b57\u6bb5\u5c11\u4e00\u4e9b\u901f\u5ea6\u4f1a\u66f4\u5feb\uff0c\u4e00\u662f\u82e5\u5b57\u6bb5\u5728\u4e00\u7d22\u5f15\u5185\uff0c\u5c31\u907f\u514d\u4e86\u53bb\u6570\u636e\u9875\u7684\u68c0\u7d22\uff0c\u4e8c\u662f\u907f\u514d\u4e86\u5927\u91cf\u6570\u636e\u7684I\/O\u64cd\u4f5c\u3002
\n\u590d\u5408\u7d22\u5f15\u4e0e\u5bf9\u5b57\u6bb5\u5206\u522b\u5efa\u7d22\u5f15\u7684\u533a\u522b\uff1a
\n1\uff0c\u590d\u5408\u7d22\u5f15\u6574\u4f53\u7a7a\u95f4\u6bd4\u5206\u522b\u5efa\u7d22\u5f15\u8981\u5c0f\u3002
\n2\uff0c\u82e5\u67e5\u8be2\u8bed\u53e5\u5bf9\u7d22\u5f15\u5185\u5b57\u6bb5\u67e5\u8be2\uff0c\u590d\u5408\u7d22\u5f15\u76f4\u63a5\u5f97\u5230\u4f4d\u7f6e\uff0c\u800c\u5206\u522b\u5efa\u7d22\u5f15\u9700\u8981\u5206\u522b\u67e5\u51fa\u518d\u8fde\u63a5
\n\u5e76\u4e14\u5f53SELECT\u5b57\u6bb5\u4e5f\u5728\u7d22\u5f15\u5185\u65f6\uff0c\u590d\u5408\u7d22\u5f15\u4f1a\u76f4\u63a5\u5f97\u51fa\uff0c\u800c\u5206\u53e6\u5efa\u7d22\u5f15\u5219\u9700\u8981\u53bb\u6570\u636e\u9875\u91cd\u65b0\u53d6\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

\u805a\u96c6\u7d22\u5f15\u53f6\u7ea7\u522b\u9664\u4e86\u4fdd\u6301\u952e\u503c\u5916\uff0c\u8fd8\u5305\u542b\u6240\u6709\u6570\u636e \u975e\u805a\u96c6\u7d22\u5f15\u53f6\u7ea7\u522b\u53ea\u6709\u9700\u8981\u7684\u952e\u503c\u53ca\u4e66\u7b7e\uff0c\u4ee5\u201c\u6587\u4ef6\u53f7\uff1a\u9875\u53f7\uff1a\u69fd\u53f7\u201d\u7684 […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[],"class_list":["post-1870","post","type-post","status-publish","format-standard","hentry","category-sql-server"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/1870","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/comments?post=1870"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/1870\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=1870"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=1870"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=1870"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}