SQL SERVER FULL-TEXT INDEX, CONTAINS return empty
- by max
Hi, All:
I got a issue about full index, any body can help me on this?
set up full text index
CREATE FULLTEXT INDEX ON dbo.Companies(my table name)
(
CompanyName(colum of my table)
Language 0X0
)
KEY INDEX IX_Companies_CompanyAlias ON QuestionsDB
WITH CHANGE_TRACKING AUTO
GO
Using CONTAINS to find the matched rows
SELECT CompanyId,…