{"id":3244,"date":"2016-07-29T00:40:25","date_gmt":"2016-07-29T00:40:25","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=3244"},"modified":"2016-07-29T00:40:25","modified_gmt":"2016-07-29T00:40:25","slug":"tsql-%e4%bb%8e%e5%86%85%e5%ae%b9%e4%b8%ad%e8%8e%b7%e5%8f%96%e7%94%b5%e8%af%9d%e5%8f%b7%e7%a0%81","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2016\/07\/29\/tsql-%e4%bb%8e%e5%86%85%e5%ae%b9%e4%b8%ad%e8%8e%b7%e5%8f%96%e7%94%b5%e8%af%9d%e5%8f%b7%e7%a0%81\/","title":{"rendered":"tsql \u4ece\u5185\u5bb9\u4e2d\u83b7\u53d6\u7535\u8bdd\u53f7\u7801"},"content":{"rendered":"<pre class=\"brush:sql;first-line:1;pad-line-numbers:true;highlight:null;collapse:false;\">\r\n\r\n\/* \r\n * \u4ece\u5185\u5bb9\u4e2d\u83b7\u53d6\u7535\u8bdd\u53f7\u7801\r\n *\/\r\n--SELECT dbo.GeTelFromContent(&#39;\u5df2\u8ba218620023427\/4&#39;)\r\nALTER function [dbo].[GeTelFromContent](@str VARCHAR(MAX))\r\nRETURNS VARCHAR(50)\r\nAS\r\nBEGIN\r\n\tDECLARE @validchars VARCHAR(100) = &#39;[1][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]&#39;\r\n\tDECLARE @idx INT,@Result VARCHAR(50)\r\n\t\r\n\tSET @idx = PATINDEX(&#39;%&#39;+ @validchars +&#39;%&#39;,@str)\r\n\t--SELECT @idx\r\n\tIF @idx &gt; 0 AND ( @idx = LEN(@str)-10 OR PATINDEX(SUBSTRING(@str,@idx+11,1),&#39;[0-9]&#39;)=0 )\r\n\tBEGIN\r\n\t\tSET @Result=SUBSTRING(@str ,PATINDEX(&#39;%&#39;+ @validchars +&#39;%&#39;,@str), 11)\r\n\tEND\r\n\tELSE\r\n\tBEGIN\r\n\t\tSET @Result = &#39;&#39;\r\n\tEND\r\n\r\n\tRETURN @Result\r\n\r\nEND\t\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\/* * \u4ece\u5185\u5bb9\u4e2d\u83b7\u53d6\u7535\u8bdd\u53f7\u7801 *\/ &#8211;SELECT dbo.GeTelFromContent(&#39;\u5df2 [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[],"class_list":["post-3244","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\/3244","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=3244"}],"version-history":[{"count":1,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/3244\/revisions"}],"predecessor-version":[{"id":3245,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/3244\/revisions\/3245"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=3244"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=3244"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=3244"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}