{"id":665,"date":"2010-10-01T08:41:59","date_gmt":"2010-10-01T08:41:59","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=665"},"modified":"2010-10-01T08:41:59","modified_gmt":"2010-10-01T08:41:59","slug":"varcharmax","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2010\/10\/01\/varcharmax\/","title":{"rendered":"VARCHAR(MAX)"},"content":{"rendered":"<p>VARCHAR(MAX),\u5b83\u7684\u6700\u5927\u957f\u5ea6\u53ef\u4ee5\u8fbe\u52302G<br \/>\n\u6ce8\u610f\uff1aVARCHAR\u548cVARCHAR(MAX)\u6df7\u5728\u4e00\u8d77\u505a\u5904\u7406\u65f6\u8fd8\u662f\u4f1a\u53d8\u6210VARCHAR\uff0c\u4ece\u800c\u53ef\u80fd\u88ab\u622a\u65ad\uff0c\u6240\u4ee5\u9700\u8981\u5168\u8f6c\u6210VARCHAR(MAX)<\/p>\n<p>DECLARE @ControlAccountS VARCHAR(MAX)<br \/>\nSET @ControlAccountS = &#8221;<br \/>\nSET @ControlAccountS = REPLICATE(CONVERT(VARCHAR(MAX),&#8217;b&#8217;),8500)<br \/>\nPRINT LEN(@ControlAccountS)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>VARCHAR(MAX),\u5b83\u7684\u6700\u5927\u957f\u5ea6\u53ef\u4ee5\u8fbe\u52302G \u6ce8\u610f\uff1aVARCHAR\u548cVARCHAR(MAX)\u6df7\u5728\u4e00\u8d77\u505a\u5904 [&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-665","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\/665","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=665"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/665\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=665"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=665"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=665"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}