CODEWITHSUNDEEP
sql-server-2008full-text-searchmultiple-columns
Rachael
Rachael

Reputation: 1993

Is it possible to create a full text index on two or more columns on the same table in MS SQL?

Is this possible, or by default is this essentially what I'm doing by creating a full text index on the entire table, specifying in my query which column to query using the 'CONTAINS(column, phrase)' function?

Thanks!

If this question has already been asked (was unable to find a match) please feel free to delete.

Upvotes: 4

Views: 3192

Answers (2)

Rachael
Rachael

Reputation: 1993

This question was already asked and answered here with an example how here.

Upvotes: 0

Rachael
Rachael

Reputation: 1993

I believe I already embarrassingly answered my own question Here, Go to Ctrl + F 'Contains( )'

Upvotes: 2

Related Questions