Replace函数的使用方法代码,MSSQL代码库,德仔网

代码语言
代码分类
【MSSQL】 Replace函数的使用方法
作者:Dezai.CN / 发布于2011/12/31/ 746
<div><span style="background-color: rgb(245, 245, 245); font-family: 'Courier New'; line-height: 1.5; white-space: pre-wrap; color: rgb(0, 0, 255); ">update</span><span style="background-color: rgb(245, 245, 245); font-family: 'Courier New'; line-height: 18px; white-space: pre-wrap; "> dbo.DomainInFo_FIp </span><span style="background-color: rgb(245, 245, 245); font-family: 'Courier New'; line-height: 1.5; white-space: pre-wrap; color: rgb(0, 0, 255); ">set</span><span style="background-color: rgb(245, 245, 245); font-family: 'Courier New'; line-height: 18px; white-space: pre-wrap; "> D_Domain</span><span style="background-color: rgb(245, 245, 245); font-family: 'Courier New'; line-height: 1.5; white-space: pre-wrap; color: rgb(128, 128, 128); ">=</span><span style="background-color: rgb(245, 245, 245); font-family: 'Courier New'; line-height: 1.5; white-space: pre-wrap; color: rgb(255, 0, 255); ">Replace</span><span style="background-color: rgb(245, 245, 245); font-family: 'Courier New'; line-height: 18px; white-space: pre-wrap; ">(D_Domain,</span><span style="background-color: rgb(245, 245, 245); font-family: 'Courier New'; line-height: 1.5; white-space: pre-wrap; color: rgb(255, 0, 0); ">'</span><span style="background-color: rgb(245, 245, 245); font-family: 'Courier New'; line-height: 1.5; white-space: pre-wrap; color: rgb(255, 0, 0); ">=</span><span style="background-color: rgb(245, 245, 245); font-family: 'Courier New'; line-height: 1.5; white-space: pre-wrap; color: rgb(255, 0, 0); ">'</span><span style="background-color: rgb(245, 245, 245); font-family: 'Courier New'; line-height: 18px; white-space: pre-wrap; ">,</span><span style="background-color: rgb(245, 245, 245); font-family: 'Courier New'; line-height: 1.5; white-space: pre-wrap; color: rgb(255, 0, 0); ">''</span><span style="background-color: rgb(245, 245, 245); font-family: 'Courier New'; line-height: 18px; white-space: pre-wrap; ">)  </span></div>
<pre style="margin-top: 0px; margin-bottom: 0px; white-space: pre-wrap; word-wrap: break-word; margin-left: 22px; font-family: 'Courier New'; line-height: 18px; background-color: rgb(245, 245, 245); "><span style="line-height: 1.5; color: rgb(0, 0, 255); ">update</span> dbo.DomainInFo_FIp <span style="line-height: 1.5; color: rgb(0, 0, 255); ">set</span> D_Domain<span style="line-height: 1.5; color: rgb(128, 128, 128); ">=</span><span style="line-height: 1.5; color: rgb(255, 0, 255); ">Replace</span>(D_Domain,<span style="line-height: 1.5; color: rgb(255, 0, 0); ">'</span><span style="line-height: 1.5; color: rgb(255, 0, 0); "><</span><span style="line-height: 1.5; color: rgb(255, 0, 0); ">'</span>,<span style="line-height: 1.5; color: rgb(255, 0, 0); ">''</span>) </pre>
<pre style="margin-top: 0px; margin-bottom: 0px; white-space: pre-wrap; word-wrap: break-word; margin-left: 22px; font-family: 'Courier New'; line-height: 18px; background-color: rgb(245, 245, 245); ">
 <span style="line-height: 1.5; color: rgb(0, 0, 255); ">update</span> dbo.DomainInFo_FIp <span style="line-height: 1.5; color: rgb(0, 0, 255); ">set</span> D_Domain<span style="line-height: 1.5; color: rgb(128, 128, 128); ">=</span><span style="line-height: 1.5; color: rgb(255, 0, 255); ">Replace</span>(D_Domain,<span style="line-height: 1.5; color: rgb(255, 0, 0); ">'</span><span style="line-height: 1.5; color: rgb(255, 0, 0); ">-</span><span style="line-height: 1.5; color: rgb(255, 0, 0); ">'</span>,<span style="line-height: 1.5; color: rgb(255, 0, 0); ">''</span>)  </pre>
<pre style="margin-top: 0px; margin-bottom: 0px; white-space: pre-wrap; word-wrap: break-word; margin-left: 22px; font-family: 'Courier New'; line-height: 18px; background-color: rgb(245, 245, 245); "><span style="line-height: 1.5; color: rgb(0, 0, 255); ">update</span> dbo.DomainInFo_FIp <span style="line-height: 1.5; color: rgb(0, 0, 255); ">set</span> D_Domain<span style="line-height: 1.5; color: rgb(128, 128, 128); ">=</span><span style="line-height: 1.5; color: rgb(255, 0, 255); ">Replace</span>(D_Domain,<span style="line-height: 1.5; color: rgb(255, 0, 0); ">'</span><span style="line-height: 1.5; color: rgb(255, 0, 0); ">~</span><span style="line-height: 1.5; color: rgb(255, 0, 0); ">'</span>,<span style="line-height: 1.5; color: rgb(255, 0, 0); ">''</span>)  </pre>
<pre style="margin-top: 0px; margin-bottom: 0px; white-space: pre-wrap; word-wrap: break-word; margin-left: 22px; font-family: 'Courier New'; line-height: 18px; background-color: rgb(245, 245, 245); "><span style="line-height: 1.5; color: rgb(0, 0, 255); ">update</span> dbo.DomainInFo_FIp <span style="line-height: 1.5; color: rgb(0, 0, 255); ">set</span> D_Domain<span style="line-height: 1.5; color: rgb(128, 128, 128); ">=</span><span style="line-height: 1.5; color: rgb(255, 0, 255); ">Replace</span>(D_Domain,<span style="line-height: 1.5; color: rgb(255, 0, 0); ">'</span><span style="line-height: 1.5; color: rgb(255, 0, 0); ">]</span><span style="line-height: 1.5; color: rgb(255, 0, 0); ">'</span>,<span style="line-height: 1.5; color: rgb(255, 0, 0); ">''</span>)  </pre>
<pre style="margin-top: 0px; margin-bottom: 0px; white-space: pre-wrap; word-wrap: break-word; margin-left: 22px; font-family: 'Courier New'; line-height: 18px; background-color: rgb(245, 245, 245); "><span style="line-height: 1.5; color: rgb(0, 0, 255); ">update</span> dbo.DomainInFo_FIp <span style="line-height: 1.5; color: rgb(0, 0, 255); ">set</span> D_Domain<span style="line-height: 1.5; color: rgb(128, 128, 128); ">=</span><span style="line-height: 1.5; color: rgb(255, 0, 255); ">Replace</span>(D_Domain,<span style="line-height: 1.5; color: rgb(255, 0, 0); ">'</span><span style="line-height: 1.5; color: rgb(255, 0, 0); ">[</span><span style="line-height: 1.5; color: rgb(255, 0, 0); ">'</span>,<span style="line-height: 1.5; color: rgb(255, 0, 0); ">''</span>)  </pre>
<pre style="margin-top: 0px; margin-bottom: 0px; white-space: pre-wrap; word-wrap: break-word; margin-left: 22px; font-family: 'Courier New'; line-height: 18px; background-color: rgb(245, 245, 245); "><span style="line-height: 1.5; color: rgb(0, 0, 255); ">update</span> dbo.DomainInFo_FIp <span style="line-height: 1.5; color: rgb(0, 0, 255); ">set</span> D_Domain<span style="line-height: 1.5; color: rgb(128, 128, 128); ">=</span><span style="line-height: 1.5; color: rgb(255, 0, 255); ">Replace</span>(D_Domain,<span style="line-height: 1.5; color: rgb(255, 0, 0); ">'</span><span style="line-height: 1.5; color: rgb(255, 0, 0); ">$</span><span style="line-height: 1.5; color: rgb(255, 0, 0); ">'</span>,<span style="line-height: 1.5; color: rgb(255, 0, 0); ">''</span>)  </pre>
<pre style="margin-top: 0px; margin-bottom: 0px; white-space: pre-wrap; word-wrap: break-word; margin-left: 22px; font-family: 'Courier New'; line-height: 18px; background-color: rgb(245, 245, 245); "><span style="line-height: 1.5; color: rgb(0, 0, 255); ">update</span> dbo.DomainInFo_FIp <span style="line-height: 1.5; color: rgb(0, 0, 255); ">set</span> D_Domain<span style="line-height: 1.5; color: rgb(128, 128, 128); ">=</span><span style="line-height: 1.5; color: rgb(255, 0, 255); ">Replace</span>(D_Domain,<span style="line-height: 1.5; color: rgb(255, 0, 0); ">'</span><span style="line-height: 1.5; color: rgb(255, 0, 0); ">{</span><span style="line-height: 1.5; color: rgb(255, 0, 0); ">'</span>,<span style="line-height: 1.5; color: rgb(255, 0, 0); ">''</span>) </pre>
<pre style="margin-top: 0px; margin-bottom: 0px; white-space: pre-wrap; word-wrap: break-word; margin-left: 22px; font-family: 'Courier New'; line-height: 18px; background-color: rgb(245, 245, 245); ">
 <span style="line-height: 1.5; color: rgb(0, 0, 255); ">update</span> dbo.DomainInFo_FIp <span style="line-height: 1.5; color: rgb(0, 0, 255); ">set</span> D_Domain<span style="line-height: 1.5; color: rgb(128, 128, 128); ">=</span><span style="line-height: 1.5; color: rgb(255, 0, 255); ">Replace</span>(D_Domain,<span style="line-height: 1.5; color: rgb(255, 0, 0); ">'</span><span style="line-height: 1.5; color: rgb(255, 0, 0); ">}</span><span style="line-height: 1.5; color: rgb(255, 0, 0); ">'</span>,<span style="line-height: 1.5; color: rgb(255, 0, 0); ">''</span>) </pre>
<pre style="margin-top: 0px; margin-bottom: 0px; white-space: pre-wrap; word-wrap: break-word; margin-left: 22px; font-family: 'Courier New'; line-height: 18px; background-color: rgb(245, 245, 245); ">
 <span style="line-height: 1.5; color: rgb(0, 0, 255); ">update</span> dbo.DomainInFo_FIp <span style="line-height: 1.5; color: rgb(0, 0, 255); ">set</span> D_Domain<span style="line-height: 1.5; color: rgb(128, 128, 128); ">=</span><span style="line-height: 1.5; color: rgb(255, 0, 255); ">Replace</span>(D_Domain,<span style="line-height: 1.5; color: rgb(255, 0, 0); ">'</span><span style="line-height: 1.5; color: rgb(255, 0, 0); ">&middot;</span><span style="line-height: 1.5; color: rgb(255, 0, 0); ">'</span>,<span style="line-height: 1.5; color: rgb(255, 0, 0); ">''</span>) </pre>
评论列表
本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。
试试其它关键字
同语言下
可能有用的
Dezai.CN贡献的其它代码(4037)