计算一表中某个字段的重复次数，游标实现代码,MSSQL代码库,德仔网

代码语言
代码分类
【MSSQL】计算一表中某个字段的重复次数，游标实现
作者:Dezai.CN / 发布于2011/12/31/ 648
<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); ">declare</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, 128, 0); ">@D_Domain</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); ">nvarchar</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(128, 0, 0); font-weight: bold; ">200</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); ">declare</span> <span style="line-height: 1.5; color: rgb(0, 128, 0); ">@count</span> <span style="line-height: 1.5; color: rgb(0, 0, 255); ">int</span>;  <span style="line-height: 1.5; color: rgb(0, 0, 255); ">Declare</span> Mycursor <span style="line-height: 1.5; color: rgb(0, 0, 255); ">cursor</span> <span style="line-height: 1.5; color: rgb(0, 0, 255); ">for</span> <span style="line-height: 1.5; color: rgb(0, 0, 255); ">select</span>  D_Domain <span style="line-height: 1.5; color: rgb(0, 0, 255); ">FROM</span> dbo.DomainInFo_FIp_log  <span style="line-height: 1.5; color: rgb(0, 0, 255); ">Open</span> Mycursor                                   <span style="line-height: 1.5; color: rgb(0, 0, 255); ">Fetch</span> <span style="line-height: 1.5; color: rgb(0, 0, 255); ">next</span> <span style="line-height: 1.5; color: rgb(0, 0, 255); ">from</span> Mycursor <span style="line-height: 1.5; color: rgb(0, 0, 255); ">into</span> <span style="line-height: 1.5; color: rgb(0, 128, 0); ">@D_Domain</span>  <span style="line-height: 1.5; color: rgb(0, 128, 128); ">--</span><span style="line-height: 1.5; color: rgb(0, 128, 128); ">开始抓数据 </span><span style="line-height: 1.5; color: rgb(0, 128, 128); "></span>  <span style="line-height: 1.5; color: rgb(0, 0, 255); ">while</span> <span style="line-height: 1.5; color: rgb(0, 128, 0); font-weight: bold; ">@@FETCH_STATUS</span> <span style="line-height: 1.5; color: rgb(128, 128, 128); ">=</span> <span style="line-height: 1.5; color: rgb(128, 0, 0); font-weight: bold; ">0</span>    <span style="line-height: 1.5; color: rgb(0, 0, 255); ">begin</span>     <span style="line-height: 1.5; color: rgb(0, 0, 255); ">select</span> <span style="line-height: 1.5; color: rgb(0, 128, 0); ">@count</span><span style="line-height: 1.5; color: rgb(128, 128, 128); ">=</span><span style="line-height: 1.5; color: rgb(255, 0, 255); ">count</span>(<span style="line-height: 1.5; color: rgb(128, 128, 128); ">*</span>) <span style="line-height: 1.5; color: rgb(0, 0, 255); ">from</span> DomainInFo_FIp_log <span style="line-height: 1.5; color: rgb(0, 0, 255); ">where</span> D_Domain<span style="line-height: 1.5; color: rgb(128, 128, 128); ">=</span><span style="line-height: 1.5; color: rgb(0, 128, 0); ">@D_Domain</span>    <span style="line-height: 1.5; color: rgb(0, 0, 255); ">update</span> DomainInFo_FIp_log <span style="line-height: 1.5; color: rgb(0, 0, 255); ">set</span> numindex<span style="line-height: 1.5; color: rgb(128, 128, 128); ">=</span><span style="line-height: 1.5; color: rgb(0, 128, 0); ">@count</span> <span style="line-height: 1.5; color: rgb(0, 0, 255); ">where</span> D_Domain<span style="line-height: 1.5; color: rgb(128, 128, 128); ">=</span><span style="line-height: 1.5; color: rgb(0, 128, 0); ">@D_Domain</span>    <span style="line-height: 1.5; color: rgb(0, 0, 255); ">Fetch</span> <span style="line-height: 1.5; color: rgb(0, 0, 255); ">next</span> <span style="line-height: 1.5; color: rgb(0, 0, 255); ">from</span> Mycursor <span style="line-height: 1.5; color: rgb(0, 0, 255); ">into</span> <span style="line-height: 1.5; color: rgb(0, 128, 0); ">@D_Domain</span>  <span style="line-height: 1.5; color: rgb(0, 0, 255); ">end</span>  <span style="line-height: 1.5; color: rgb(0, 0, 255); ">Close</span> Mycursor                         <span style="line-height: 1.5; color: rgb(0, 128, 128); ">--</span><span style="line-height: 1.5; color: rgb(0, 128, 128); ">关闭游标 </span><span style="line-height: 1.5; color: rgb(0, 128, 128); "></span>  <span style="line-height: 1.5; color: rgb(0, 0, 255); ">Deallocate</span> Mycursor                    <span style="line-height: 1.5; color: rgb(0, 128, 128); ">--</span><span style="line-height: 1.5; color: rgb(0, 128, 128); ">删除游标 </span></pre>
试试其它关键字
　重复次数　
同语言下
可能有用的
Dezai.CN贡献的其它代码(4037)