| QUESTIONS | CATEGORIES | BLOG | PROFILE | Login | Register |
ASK QUESTION
Computers → Computer software → Database software → Microsoft SQL Server
ANSWERS: 1
  • ksrover
    In the Server Management Studio, connect to your server and locate the database and table(s) you wish to use full-text indexing with. Right-click the table and choose 'Full-text Index'->'Define full-text index' from the dropdown menu. This will start the wizard for Full-text indexing. An example of FREETEXT: SELECT colA, colB FROM TableA WHERE FREETEXT (colB, 'some search string' ); This returns all colB containing the words related to 'some', 'search', and 'string'. Keep in mind though that using FREETEXT isn't as accurate as using CONTAINS.
    No comments

RELATED QUESTIONS

ABOUT ANSWERBAG

Answerbag wants to provide a service to people looking for answers and a good conversation. Ask away and we will do our best to answer or find someone who can.We try to vet our answers to get you the most acurate answers.

Copyright 2023, Wired Ivy, LLC

Answerbag | Terms of Service | Privacy Policy