Ò».È¥³ý×Ö·û´®ÖеÄhtml±ê¼Ç¼°±ê¼ÇÖеÄÄÚÈÝ

<div class="blogpost-body" id="cnblogs_post_body">
<p><span lang="en-us" style="font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:26px;text-align:left;text-indent:0px;text-transform:none;word-spacing:0px;font-size:10pt;color:#008000;font-family:&#39;Courier New&#39;;">--1</span><span style="font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:26px;text-align:left;text-indent:0px;text-transform:none;word-spacing:0px;font-size:10pt;color:#008000;font-family:&#39;ËÎÌå&#39;;">¡¢´´½¨º¯Êý</span></p>
<p><span style="font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:26px;text-align:left;text-indent:0px;text-transform:none;word-spacing:0px;font-size:10pt;color:#008000;font-family:&#39;ËÎÌå&#39;;"> </span></p>
<div class="cnblogs_code">
  <pre class="blockcode"><span style="color:#0000ff;">create</span> <span style="color:#0000ff;">function</span> <span style="color:#ff0000;">[</span><span style="color:#ff0000;">dbo</span><span style="color:#ff0000;">]</span>.<span style="color:#ff0000;">[</span><span style="color:#ff0000;">clearhtml</span><span style="color:#ff0000;">]</span> (<span style="color:#008000;">&#64;maco</span> <span style="color:#0000ff;">varchar</span>(<span style="color:#800000;font-weight:bold;">8000</span><span style="color:#000000;">))
</span><span style="color:#0000ff;">returns</span> <span style="color:#0000ff;">varchar</span>(<span style="color:#800000;font-weight:bold;">8000</span>) <span style="color:#0000ff;">as</span> <span style="color:#0000ff;">begin</span>
    <span style="color:#0000ff;">declare</span> <span style="color:#008000;">&#64;i</span> <span style="color:#0000ff;">int</span>
    <span style="color:#0000ff;">while</span> <span style="color:#800000;font-weight:bold;">1</span> <span style="color:#808080;">&#61;</span> <span style="color:#800000;font-weight:bold;">1</span>
    <span style="color:#0000ff;">begin</span>
       <span style="color:#0000ff;">set</span> <span style="color:#008000;">&#64;i</span><span style="color:#808080;">&#61;</span><span style="color:#ff00ff;">len</span>(<span style="color:#008000;">&#64;maco</span><span style="color:#000000;">)
       </span><span style="color:#0000ff;">set</span> <span style="color:#008000;">&#64;maco</span><span style="color:#808080;">&#61;</span><span style="color:#ff00ff;">replace</span>(<span style="color:#008000;">&#64;maco</span>, <span style="color:#ff00ff;">substring</span>(<span style="color:#008000;">&#64;maco</span>,<span style="color:#ff00ff;">charindex</span>(<span style="color:#ff0000;">&#39;</span><span style="color:#ff0000;">&lt;</span><span style="color:#ff0000;">&#39;</span>,<span style="color:#008000;">&#64;maco</span><span style="color:#000000;">),
       </span><span style="color:#ff00ff;">charindex</span>(<span style="color:#ff0000;">&#39;</span><span style="color:#ff0000;">&gt;</span><span style="color:#ff0000;">&#39;</span>,<span style="color:#008000;">&#64;maco</span>)<span style="color:#808080;">-</span><span style="color:#ff00ff;">charindex</span>(<span style="color:#ff0000;">&#39;</span><span style="color:#ff0000;">&lt;</span><span style="color:#ff0000;">&#39;</span>,<span style="color:#008000;">&#64;maco</span>)<span style="color:#808080;">&#43;</span><span style="color:#800000;font-weight:bold;">1</span>),<span style="color:#ff00ff;">space</span>(<span style="color:#800000;font-weight:bold;">0</span><span style="color:#000000;">))
       </span><span style="color:#0000ff;">if</span> <span style="color:#008000;">&#64;i</span><span style="color:#808080;">&#61;</span><span style="color:#ff00ff;">len</span>( <span style="color:#008000;">&#64;maco</span><span style="color:#000000;"> )
       </span><span style="color:#0000ff;">break</span>
    <span style="color:#0000ff;">end</span>

    <span style="color:#0000ff;">set</span> <span style="color:#008000;">&#64;maco</span><span style="color:#808080;">&#61;</span><span style="color:#ff00ff;">replace</span>(<span style="color:#008000;">&#64;maco</span>,<span style="color:#ff0000;">&#39;</span> <span style="color:#ff0000;">&#39;</span>,<span style="color:#ff0000;">&#39;&#39;</span><span style="color:#000000;">)
    </span><span style="color:#0000ff;">set</span> <span style="color:#008000;">&#64;maco</span><span style="color:#808080;">&#61;</span><span style="color:#ff00ff;">replace</span>(<span style="color:#008000;">&#64;maco</span>,<span style="color:#ff0000;">&#39;</span><span style="color:#ff0000;">&amp;nbsp;</span><span style="color:#ff0000;">&#39;</span>,<span style="color:#ff0000;">&#39;&#39;</span><span style="color:#000000;">)
    </span><span style="color:#0000ff;">set</span> <span style="color:#008000;">&#64;maco</span><span style="color:#808080;">&#61;</span><span style="color:#ff00ff;">ltrim</span>(<span style="color:#ff00ff;">rtrim</span>(<span style="color:#008000;">&#64;maco</span><span style="color:#000000;">))
    </span><span style="color:#0000ff;">set</span> <span style="color:#008000;">&#64;maco</span><span style="color:#808080;">&#61;</span><span style="color:#ff00ff;">replace</span>(<span style="color:#008000;">&#64;maco</span>,<span style="color:#0000ff;">char</span>(<span style="color:#800000;font-weight:bold;">9</span>),<span style="color:#ff0000;">&#39;&#39;</span><span style="color:#000000;">)
    </span><span style="color:#0000ff;">set</span> <span style="color:#008000;">&#64;mac