{"id":1316,"date":"2010-11-09T02:31:10","date_gmt":"2010-11-09T02:31:10","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=1316"},"modified":"2010-11-09T03:06:18","modified_gmt":"2010-11-09T03:06:18","slug":"for%e5%be%aa%e7%8e%af%e7%9a%84%e5%ae%9e%e7%8e%b0","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2010\/11\/09\/for%e5%be%aa%e7%8e%af%e7%9a%84%e5%ae%9e%e7%8e%b0\/","title":{"rendered":"for\u5faa\u73af\u7684\u5b9e\u73b0"},"content":{"rendered":"<pre lang=\"tsql\">\r\n1\uff0c\u5c06\u5faa\u73af\u56e0\u5b501\uff0c2\uff0c3\uff0c4\uff0c5....\u5b58\u5165\u4e00\u8868\u4e2d\uff0c\u7528\u6b64\u8868\u4e0e\u76ee\u6807\u8868\u8fdb\u884c\u5173\u8054\u5373\u53ef\u3002\r\n2\uff0c\u4f8b\u5b50\uff1a\u63d0\u53d6 \u5b57\u7b26\u4e32  \u201813604784785\u859b\u5c0f\u59d0\u2019\u975e\u4e2d\u6587\u90e8\u5206\r\ncreate table #tt(n int)          --\u5faa\u73af\u6570\r\ndeclare @tt int\r\nset @tt=1\r\nwhile @tt<=200\r\nbegin\r\n        insert #tt values(@tt)\r\n        set @tt=@tt+1\r\nEND\r\nCREATE TABLE #ts(tel VARCHAR(100))\r\nINSERT INTO #ts VALUES ('13604784785\u859b\u5c0f\u59d0')\r\n\r\ndeclare @string varchar(200)\r\nSELECT TOP 1 *,SUBSTRING(tel,1,n-1) FROM (\r\nSELECT tel,n,case when SUBSTRING(tel,n,1) LIKE '[0-9]' THEN NULL ELSE STUFF(tel,n,0,'#') END AS 'string'\r\nFROM #ts JOIN #tt ON n < LEN(#ts.tel))m1\r\nWHERE m1.string IS NOT null\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>1\uff0c\u5c06\u5faa\u73af\u56e0\u5b501\uff0c2\uff0c3\uff0c4\uff0c5&#8230;.\u5b58\u5165\u4e00\u8868\u4e2d\uff0c\u7528\u6b64\u8868\u4e0e\u76ee\u6807\u8868\u8fdb\u884c\u5173\u8054\u5373\u53ef\u3002 2\uff0c\u4f8b\u5b50\uff1a\u63d0\u53d6 \u5b57\u7b26\u4e32 \u20181 [&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-1316","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\/1316","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=1316"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/1316\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=1316"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=1316"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=1316"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}