Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why not getting any results?
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Indexation intégral de texte
Versions des environnements
SQL Server:
SQL Server 2000
Application:
Desktop
Divers
Thread ID:
01365575
Message ID:
01365664
Vues:
9
Do you get any results for regular queries?
select * from masterFL where descr LIKE '%green%'
select * from masterFL where note LIKE '%green%'
>I'm running the following lines and getting no errors. But also not getting any results what am I doing wrong?
>
>
>--create a catalog
>EXEC sp_fulltext_catalog 'ims', 'create'
>
>--create table / PK
>EXEC sp_fulltext_table 'masterFL', 'create', 'ims', 'pk_MasterFL'
>
>--Add some columns
>EXEC sp_fulltext_column 'masterFL','Descr','add'
>EXEC sp_fulltext_column 'masterFL','note','add'
>
>--Activate and populate the index
>EXEC sp_fulltext_table 'masterFL', 'activate'
>EXEC sp_fulltext_table 'masterFL', 'start_full'
>
>--activate and propagate  
>EXEC sp_fulltext_catalog 'ims', 'start_full'
>
>-- test it...
>select * from masterFL where contains(descr, 'green')
>select * from masterFL where contains(note, 'green')
>
>--To remove a full-text index
>--EXEC sp_fulltext_table 'ims', 'drop'
>
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform