Full Text Search in SQL Server

USE AdventureWorks;
GO
CREATE UNIQUE INDEX ui_ukJobCand ON HumanResources.JobCandidate(JobCandidateID);
CREATE FULLTEXT CATALOG ft AS DEFAULT;
CREATE FULLTEXT INDEX ON HumanResources.JobCandidate(Resume) KEY INDEX ui_ukJobCand;
GO


SELECT *
FROM HumanResources.JobCandidate
WHERE CONTAINS(Resume, 'Production');
GO

No comments: