Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 CONTAINS in SQL server

Author  Topic 

benildusmuerling
Yak Posting Veteran

81 Posts

Posted - 2012-08-16 : 23:45:38
Hi My Dear Friends,

Good day to you guys, I would like to get some help in asking, how would I be able to implement the CONTAINS in SQL server.

Please shoot some examples, in explaining how to do it.

Thanks,

AB.

benildusmuerling
Yak Posting Veteran

81 Posts

Posted - 2012-08-17 : 01:19:53
Can anyone, tell me why am I getting an error as below please, wouldnt I be able to use #tables or table variables.

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.
Go to Top of Page

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2012-08-17 : 06:39:44
The error is self explanatory.

http://msdn.microsoft.com/en-us/library/ms187787.aspx








How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Go to Top of Page
   

- Advertisement -