SQL Server Performance

CONTAINS keyword in SQL Server

Discussion in 'ALL SQL SERVER QUESTIONS' started by Antonio Benildus Muerling, Aug 16, 2012.

  1. My Dear Good Friends,

    Please be good enough to help me saying how would I able to use the contains in SQL server, would anyone able to help me and say, what is the most appropriate way for using the contains keyword.

    When I am using the contains with a #table or a table variable, am getting the below error.

    "Msg 7601, Level 16, State 2, Line 15

    Cannot use a CONTAINS or FREETEXT predicate on table or indexed view '#drop' because it is not full-text indexed."


  2. MichaelB Member

Share This Page