Why is my full text search not working in SQL Server? -


table columns:

enter image description here

table data:

enter image description here

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

Popular posts from this blog

account - Script error login visual studio DefaultLogin_PCore.js -

xcode - CocoaPod Storyboard error: -