Why is my full text search not working in SQL Server? -
table columns:
table data:
full text index definition:
create unique index idx_fulltext_workorder on workorder(id); create fulltext index on workorder (description) key index idx_fulltext_workorder on full_text_catalog;
query:
select * [dbo].[workorder] contains([description], '"priorité 8"')
incorrect result: 9 (all) rows of table, instead of single 1 corresponding query.
also why query (notice * character):
select * [dbo].[workorder] contains([description], '"priorité 8*"')
not returning result @ (0)?
Comments
Post a Comment