How do I enable full-text search function in SQL?
-------------------------------------------------- ------------------------------ Full-text index, use in the query analyzer: Use Pubsgo - Open the database index support execute sp_fulltext_database 'enable'go-- full-text catalog ft_titlesexecute sp_fulltext_catalog' ft_titles ',' create'go-- full-text indexed to the titles table data element, UPKCL_titleidind the primary key is a unique index created, that can be sp_help titles execute sp_fulltext_table 'titles', 'create', 'ft_titles', 'UPKCL_titleidind'go-- set the full-text index column names exec sp_fulltext_column' titles ',' title ',' add'goexec sp_fulltext_column 'titles', 'notes', 'add' go-- full-text indexed exec sp_fulltext_table 'titles',' activate'go-- filled with full-text index catalog exec sp_fulltext_catalog 'ft_titles',' start_full'go-- use and contains freetextselect title, notes from titleswhere contains (title, ' "computer Cooking " ') goselect title, notes from titleswhere freetext (title,' computer Cooking ') goselect title, notes from titleswhere freetext (title,'" computer Cooking " ') goselect title, notes from titleswhere contains (title,' computer ') Gosect Title, Notes from Titleswhere Fretext (*, 'Computer') Go
