{"id":1734,"date":"2011-05-17T04:08:46","date_gmt":"2011-05-17T04:08:46","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=1734"},"modified":"2011-05-17T04:45:33","modified_gmt":"2011-05-17T04:45:33","slug":"sql%e5%ad%97%e7%ac%a6%e4%b8%b2%e6%8b%bc%e6%8e%a5%e5%bc%95%e5%8f%b7%e9%97%ae%e9%a2%98","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2011\/05\/17\/sql%e5%ad%97%e7%ac%a6%e4%b8%b2%e6%8b%bc%e6%8e%a5%e5%bc%95%e5%8f%b7%e9%97%ae%e9%a2%98\/","title":{"rendered":"sql\u5b57\u7b26\u4e32\u62fc\u63a5\u5f15\u53f7\u95ee\u9898"},"content":{"rendered":"<p>\u5728\u7528@sql\u62fc\u8bed\u53e5\u65f6\uff0c\u5bf9\u4e8e\u5b57\u7b26\u4e32\u53d8\u91cf\uff0c\u8981\u4f20\u5927\u91cf\u7684\u5f15\u53f7\uff0c\u56e0\u4e3a\u8981\u7528&#8221;&#8221;\u8868\u793a\u4e00\u4e2a\u5f15\u53f7<br \/>\n\u5982\uff1a.<br \/>\nDECLARE @tname VARCHAR(10)<br \/>\nDECLARE @sql1 VARCHAR(MAX),@sql2 VARCHAR(MAX)<br \/>\nSET @tname = &#8216;\u76ae\u677e\u8c0a&#8217;<br \/>\nSET @sql1 = &#8216;select * from frmuser where username =  &#8216; + &#8221;&#8221; + @tname + &#8221;&#8221;<br \/>\nEXEC ( @sql1 )<\/p>\n<p>\u5176\u5b9e\u53ef\u7528sql server\u63d0\u4f9b\u7684\u5185\u7f6e\u51fd\u6570quotename\u89e3\u51b3<br \/>\nSET @sql1 = &#8216;select * from frmuser where username =  &#8216; + quotename(@tname,&#8221;&#8221;)<br \/>\nEXEC ( @sql1 )<\/p>\n<p>\u6ce8\uff1aQUOTENAME ( &#8216;character_string&#8217; [ , &#8216;quote_character&#8217; ] )<br \/>\n&#8216;quote_character&#8217;:<br \/>\n\u7528\u4f5c\u5206\u9694\u7b26\u7684\u5355\u5b57\u7b26\u5b57\u7b26\u4e32\u3002\u53ef\u4ee5\u662f\u5355\u5f15\u53f7 (&#8216;)\u3001\u5de6\u65b9\u62ec\u53f7\u6216\u53f3\u65b9\u62ec\u53f7 ([ ]) \u6216\u8005\u82f1\u6587\u53cc\u5f15\u53f7 (&#8220;)\u3002\u5982\u679c\u672a\u6307\u5b9a quote_character\uff0c\u5219\u4f7f\u7528\u65b9\u62ec\u53f7\u3002 \u65b9\u62ec\u53f7\u53ef\u7528\u4e8e\u8868\u540d<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5728\u7528@sql\u62fc\u8bed\u53e5\u65f6\uff0c\u5bf9\u4e8e\u5b57\u7b26\u4e32\u53d8\u91cf\uff0c\u8981\u4f20\u5927\u91cf\u7684\u5f15\u53f7\uff0c\u56e0\u4e3a\u8981\u7528&#8221;&#8221;\u8868\u793a\u4e00\u4e2a\u5f15\u53f7 \u5982\uff1a. [&hellip;]<\/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-1734","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\/1734","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=1734"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/1734\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=1734"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=1734"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=1734"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}