full text index

full text index求助
SQL2008R2, SQL Full-text服务已启动.
测试如下,为何结果总是返回0笔呢.

SQL code

create database DBAPuse DBAPcreate table tb5( tsid int not null,  tsde char(8000),  descr varchar(30)  constraint pk_tb5 primary key clustered(tsid))create index idx_tb5_descr on tb5(descr)set nocount ondeclare @x int=1while @x<=100000begin   insert into tb5(tsid,tsde,descr)     values(@x,'313ccx',rtrim(@x)+'cxccx')    select @x=@x+1endset nocount offif(select databaseproperty('DBAP','isfulltextenabled'))=0    execute sp_fulltext_database 'enable'execute sp_fulltext_catalog 'ft_pubs','create','D:\sqldata\ft'execute sp_fulltext_table 'tb5','create','ft_pubs','pk_tb5'execute sp_fulltext_column 'tb5','descr','add'execute sp_fulltext_table 'tb5','activate'execute sp_fulltext_catalog 'ft_pubs','start_full'while fulltextcatalogproperty('ft_pubs','populateStatus')<>0begin  waitfor delay '00:00:05'end--问题..为何总是返回0呢?select count(1)from tb5where contains(descr,'35')

[解决办法]
contains中判断的字段要在select中出现吧。
试试：
select descr
from tb5
where contains(descr,'35')

[解决办法]
contains用法唐诗看看这个，希望对你有帮助。

查看更多 下一篇