一个全文检索完整的例子代码,MSSQL代码库,德仔网

代码语言
代码分类
【MSSQL】一个全文检索完整的例子
作者:Dezai.CN / 发布于2011/11/22/ 797
<div><span style="color: rgb(0,0,255)">Create</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">Table</span><span style="color: rgb(0,0,0)"> testIndex 
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" />( 
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /> id </span><strong>int</strong><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,255)">identity</span><span style="color: rgb(0,0,0)">(</span><strong>1</strong><span style="color: rgb(0,0,0)">,</span><strong>1</strong><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(0,0,255)">primary</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">key</span><span style="color: rgb(0,0,0)">, 
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /> nm </span><strong>varchar</strong><span style="color: rgb(0,0,0)">(</span><strong>100</strong><span style="color: rgb(0,0,0)">) </span><span style="color: rgb(0,0,255)">unique</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">not</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">null</span><span style="color: rgb(0,0,0)">, 
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /> sex </span><strong>varchar</strong><span style="color: rgb(0,0,0)">(</span><strong>10</strong><span style="color: rgb(0,0,0)">) 
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" />) 
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span><span style="color: rgb(0,0,255)">create</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">UNIQUE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">index</span><span style="color: rgb(0,0,0)"> UQ__testIndex__0DAF0CB0
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span><span style="color: rgb(0,0,255)">on</span><span style="color: rgb(0,0,0)"> testindex(nm)
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" />
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span><span style="color: rgb(0,0,255)">insert</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">into</span><span style="color: rgb(0,0,0)"> testindex 
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /> </span><span style="color: rgb(0,0,255)">select</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">aaabbb</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">m</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">union</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">all</span><span style="color: rgb(0,0,0)"> 
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /> </span><span style="color: rgb(0,0,255)">select</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">bbb</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">w</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">union</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">all</span><span style="color: rgb(0,0,0)"> 
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /> </span><span style="color: rgb(0,0,255)">select</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">ccc</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">w</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">union</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">all</span><span style="color: rgb(0,0,0)"> 
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /> </span><span style="color: rgb(0,0,255)">select</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">ddd</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">m</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> 
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" />
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span></div>
<div><span style="color: rgb(0,0,0)">
准备一组汉字记录
<div style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; padding-bottom: 4px; background-color: rgb(230,230,230); padding-left: 5.4pt; width: 659px; padding-right: 5.4pt; word-break: break-all; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid; padding-top: 4px">
<div><img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /><span style="color: rgb(0,0,255)">insert</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">into</span><span style="color: rgb(0,0,0)"> testindex 
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /> </span><span style="color: rgb(0,0,255)">select</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">麦蒂未伤愈中途退出训练复出时间再度成疑</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">北京</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> 
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span><span style="color: rgb(0,0,255)">go</span></div>
</div>

--创建全文目录 

<div style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; padding-bottom: 4px; background-color: rgb(230,230,230); padding-left: 5.4pt; width: 659px; padding-right: 5.4pt; word-break: break-all; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid; padding-top: 4px">
<div><img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /><span style="color: rgb(0,0,0)">sp_fulltext_catalog </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">abc</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">create</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> 
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span><span style="color: rgb(0,0,255)">go</span></div>
</div>

--创建全文索引（&lsquo;表名&lsquo;，&rsquo;创建/删除&lsquo;，&rsquo;全文目录名&lsquo;，&rsquo;约束名&lsquo;） 

<div style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; padding-bottom: 4px; background-color: rgb(230,230,230); padding-left: 5.4pt; width: 659px; padding-right: 5.4pt; word-break: break-all; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid; padding-top: 4px">
<div><img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /><span style="color: rgb(0,0,0)">sp_fulltext_table </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">testindex</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">create</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">abc</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">UQ__testIndex__0DAF0CB0</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> 
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span><span style="color: rgb(0,0,255)">go</span></div>
</div>

--添加列到全文索引（&lsquo;表名&lsquo;，&rsquo;列名&lsquo;，&rsquo;添加/删除&lsquo;） 

<div style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; padding-bottom: 4px; background-color: rgb(230,230,230); padding-left: 5.4pt; width: 659px; padding-right: 5.4pt; word-break: break-all; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid; padding-top: 4px">
<div><img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /><span style="color: rgb(0,0,0)">sp_fulltext_column </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">testindex</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">nm</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">add</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> 
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" />
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span><span style="color: rgb(0,0,255)">go</span><span style="color: rgb(0,0,0)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span></div>
</div>

--建立全文索引
--activate，是激活表的全文检索能力，也就是在全文目录中注册该表

<div style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; padding-bottom: 4px; background-color: rgb(230,230,230); padding-left: 5.4pt; width: 659px; padding-right: 5.4pt; word-break: break-all; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid; padding-top: 4px">
<div><img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /><span style="color: rgb(0,0,255)">execute</span><span style="color: rgb(0,0,0)"> sp_fulltext_table </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">testindex</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">activate</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span><span style="color: rgb(0,0,255)">go</span></div>
</div>

--填充全文索引目录

<div style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; padding-bottom: 4px; background-color: rgb(230,230,230); padding-left: 5.4pt; width: 659px; padding-right: 5.4pt; word-break: break-all; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid; padding-top: 4px">
<div><img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /><span style="color: rgb(0,0,255)">execute</span><span style="color: rgb(0,0,0)"> sp_fulltext_catalog </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">abc</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">start_full</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span><span style="color: rgb(0,0,255)">go</span></div>
</div>

--检查全文目录填充情况

<div style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; padding-bottom: 4px; background-color: rgb(230,230,230); padding-left: 5.4pt; width: 659px; padding-right: 5.4pt; word-break: break-all; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid; padding-top: 4px">
<div><img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /><span style="color: rgb(0,0,255)">While</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,255)">fulltextcatalogproperty</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">abc</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">populateStatus</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">)</span><span style="color: rgb(128,128,128)"><></span><strong>0</strong><span style="color: rgb(0,0,0)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span><span style="color: rgb(0,0,255)">begin</span><span style="color: rgb(0,0,0)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" />
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)">如果全文目录正处于填充状态，则等待30秒后再检测一次</span><span style="color: rgb(0,128,128)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span><span style="color: rgb(0,0,255)">waitfor</span><span style="color: rgb(0,0,0)"> delay </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">0:0:30</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span><span style="color: rgb(0,0,255)">end</span><span style="color: rgb(0,0,0)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span></div>
</div>

--全文目录填充完成后，即可使用全文目录检索

<div style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; padding-bottom: 4px; background-color: rgb(230,230,230); padding-left: 5.4pt; width: 659px; padding-right: 5.4pt; word-break: break-all; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid; padding-top: 4px">
<div><img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">FROM</span><span style="color: rgb(0,0,0)"> testindex </span><span style="color: rgb(0,0,255)">WHERE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">CONTAINS</span><span style="color: rgb(0,0,0)">(nm, </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">麦蒂</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">) 
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" />
<img id="_63_420_Open_Image" alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/ExpandedBlockStart.gif" /></span><span id="_63_420_Open_Text"><span style="color: rgb(0,128,128)">/*</span><span style="color: rgb(0,128,128)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif" />
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif" />id nm sex 
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif" />----------- --------------------------------------------- ------------------------------------------------ ---------- 
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif" />5 麦蒂未伤愈中途退出训练复出时间再度成疑 北京
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif" />
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif" />（所影响的行数为 1 行）
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/ExpandedBlockEnd.gif" /></span><span style="color: rgb(0,128,128)">*/</span></span><span style="color: rgb(0,0,0)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" />
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span></div>
</div>

再次插入新的数据，

<div style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; padding-bottom: 4px; background-color: rgb(230,230,230); padding-left: 5.4pt; width: 659px; padding-right: 5.4pt; word-break: break-all; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid; padding-top: 4px">
<div><img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /><span style="color: rgb(0,0,0)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span><span style="color: rgb(0,0,255)">insert</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">into</span><span style="color: rgb(0,0,0)"> testindex 
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /> </span><span style="color: rgb(0,0,255)">select</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">麦蒂未伤愈中途退出训练复出时间再度成疑12121</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">北京</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> 
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span><span style="color: rgb(0,0,255)">go</span><span style="color: rgb(0,0,0)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">FROM</span><span style="color: rgb(0,0,0)"> testindex </span><span style="color: rgb(0,0,255)">WHERE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">CONTAINS</span><span style="color: rgb(0,0,0)">(nm, </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">麦蒂</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">)
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)">---这个时候进行select实际上得不到理想的结果，还是老数据，没有增加的这一条</span><span style="color: rgb(0,128,128)">
<img id="_191_548_Open_Image" alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/ExpandedBlockStart.gif" /></span><span id="_191_548_Open_Text"><span style="color: rgb(0,128,128)">/*</span><span style="color: rgb(0,128,128)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif" />
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif" />id nm sex 
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif" />----------- --------------------------------------------- ------------------------------------------------ ---------- 
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif" />5 麦蒂未伤愈中途退出训练复出时间再度成疑 北京
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif" />
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif" />（所影响的行数为 1 行）
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/ExpandedBlockEnd.gif" /></span><span style="color: rgb(0,128,128)">*/</span></span><span style="color: rgb(0,0,0)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span><span style="color: rgb(0,0,255)">go</span><span style="color: rgb(0,0,0)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" />
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span></div>
</div>

--填充全文索引目录

<div style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; padding-bottom: 4px; background-color: rgb(230,230,230); padding-left: 5.4pt; width: 659px; padding-right: 5.4pt; word-break: break-all; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid; padding-top: 4px">
<div><img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /><span style="color: rgb(0,0,255)">execute</span><span style="color: rgb(0,0,0)"> sp_fulltext_catalog </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">abc</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">start_full</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span><span style="color: rgb(0,0,255)">go</span><span style="color: rgb(0,0,0)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span></div>
</div>

--检查全文目录填充情况

<div style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; padding-bottom: 4px; background-color: rgb(230,230,230); padding-left: 5.4pt; width: 659px; padding-right: 5.4pt; word-break: break-all; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid; padding-top: 4px">
<div><img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /><span style="color: rgb(0,0,255)">While</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,255)">fulltextcatalogproperty</span><span style="color: rgb(0,0,0)">(</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">abc</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">populateStatus</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">)</span><span style="color: rgb(128,128,128)"><></span><strong>0</strong><span style="color: rgb(0,0,0)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span><span style="color: rgb(0,0,255)">begin</span><span style="color: rgb(0,0,0)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" />
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)">如果全文目录正处于填充状态，则等待30秒后再检测一次</span><span style="color: rgb(0,128,128)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span><span style="color: rgb(0,0,255)">waitfor</span><span style="color: rgb(0,0,0)"> delay </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">0:0:30</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span><span style="color: rgb(0,0,255)">end</span><span style="color: rgb(0,0,0)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" />
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span></div>
</div>

--重新填充后就会有想要的结果　了

<div style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; padding-bottom: 4px; background-color: rgb(230,230,230); padding-left: 5.4pt; width: 659px; padding-right: 5.4pt; word-break: break-all; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid; padding-top: 4px">
<div><img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /><span style="color: rgb(0,0,255)">SELECT</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">FROM</span><span style="color: rgb(0,0,0)"> testindex </span><span style="color: rgb(0,0,255)">WHERE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">CONTAINS</span><span style="color: rgb(0,0,0)">(nm, </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">麦蒂</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">)
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" />
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span><span style="color: rgb(0,0,255)">go</span><span style="color: rgb(0,0,0)">
<img id="_65_568_Open_Image" alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/ExpandedBlockStart.gif" /></span><span id="_65_568_Open_Text"><span style="color: rgb(0,128,128)">/*</span><span style="color: rgb(0,128,128)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif" />
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif" />id nm sex 
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif" />----------- ---------------------------------------------------------------------------------------------------- ---------- 
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif" />6 麦蒂未伤愈中途退出训练复出时间再度成疑12121 北京
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif" />5 麦蒂未伤愈中途退出训练复出时间再度成疑 北京
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif" />
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif" />（所影响的行数为 2 行）
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/InBlock.gif" />
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/ExpandedBlockEnd.gif" /></span><span style="color: rgb(0,128,128)">*/</span></span><span style="color: rgb(0,0,0)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" />
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span></div>
</div>
--清理现场

<div style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; padding-bottom: 4px; background-color: rgb(230,230,230); padding-left: 5.4pt; width: 659px; padding-right: 5.4pt; word-break: break-all; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid; padding-top: 4px">
<div><img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /><span style="color: rgb(0,0,0)">sp_fulltext_table </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">testindex</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">drop</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span><span style="color: rgb(0,0,255)">go</span><span style="color: rgb(0,0,0)">
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" />sp_fulltext_catalog </span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">abc</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)">,</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(255,0,0)">drop</span><span style="color: rgb(255,0,0)">'</span><span style="color: rgb(0,0,0)"> 
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span><span style="color: rgb(0,0,255)">go</span><span style="color: rgb(0,0,0)"> 
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span><span style="color: rgb(0,0,255)">drop</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">table</span><span style="color: rgb(0,0,0)"> testIndex 
<img alt="" align="top" src="http://images.csdn.net/syntaxhighlighting/OutliningIndicators/None.gif" /></span></div>
</div>

</span></div>
<div></div>
试试其它关键字
　全文检索　
同语言下
可能有用的
Dezai.CN贡献的其它代码(4037)