我想创建全文索引,来实现全文搜索,我的sql如下use dbase
go
if(select databaseproperty('dbase','IsFulltextEnables'))=0
--create unique index unid on zps(序号)
exec sp_fulltext_database 'enable'
execute sp_fulltext_catalog 'FT_pubs3','create'
execute sp_fulltext_table 'zps','create','FT_pubs3','unid'
execute sp_fulltext_column 'zps','名称','add'
execute sp_fulltext_column 'zps','简介','add'
execute sp_fulltext_table zps,'activate'
execute sp_fulltext_catalog 'FT_pubs3','start_full'
go提示全部成功,但当我使用
SELECT fulltextcatalogproperty('FT_pubs3', 'PopulateStatus')
来查看时,发现返回值总是0,也就是说没有数据填充进去,大侠帮忙
go
if(select databaseproperty('dbase','IsFulltextEnables'))=0
--create unique index unid on zps(序号)
exec sp_fulltext_database 'enable'
execute sp_fulltext_catalog 'FT_pubs3','create'
execute sp_fulltext_table 'zps','create','FT_pubs3','unid'
execute sp_fulltext_column 'zps','名称','add'
execute sp_fulltext_column 'zps','简介','add'
execute sp_fulltext_table zps,'activate'
execute sp_fulltext_catalog 'FT_pubs3','start_full'
go提示全部成功,但当我使用
SELECT fulltextcatalogproperty('FT_pubs3', 'PopulateStatus')
来查看时,发现返回值总是0,也就是说没有数据填充进去,大侠帮忙
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货