相同结构表去重复后进行复制代码,MSSQL代码库,德仔网

代码语言

代码分类

【MSSQL】相同结构表去重复后进行复制

作者:Dezai.CN / 发布于2011/12/31/ 901

<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); ">insert</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(0, 0, 255); ">into</span><span style="background-color: rgb(245, 245, 245); font-family: 'Courier New'; line-height: 18px; white-space: pre-wrap; "> 新表名select  DomainInFo_FIp.D_Domain,源表名.D_ID,源表名.D_IP,源表名.stat </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); ">from</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); ">
inner <span style="line-height: 1.5; color: rgb(128, 128, 128); ">join</span>  (<span style="line-height: 1.5; color: rgb(0, 0, 255); ">select</span> <span style="line-height: 1.5; color: rgb(255, 0, 255); ">min</span>(D_ID) D_ID,<span style="line-height: 1.5; color: rgb(0, 0, 255); ">distinct</span>(D_Domain) <span style="line-height: 1.5; color: rgb(0, 0, 255); ">as</span> D_Domain  <span style="line-height: 1.5; color: rgb(0, 0, 255); ">from</span> 源表名) TempTab <span style="line-height: 1.5; color: rgb(0, 0, 255); ">on</span> 源表名.D_ID <span style="line-height: 1.5; color: rgb(128, 128, 128); ">=</span> TempTab.D_ID </pre>

试试其它关键字

　相同结构表　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)