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.
| Author |
Topic |
|
Jason_D
Starting Member
11 Posts |
 Posted - 2002-06-28 : 14:56:56
|
| Hello All...What is the difference between the "CONTAINS" and "CONTAINSTABLE" functions and how are they implemented? If you could even direct me towards some literature that would also be sufficient (I've taken a few books out at the library and searched the net but I have not yet been successful).Thanks,Jason |
|
|
MuffinMan
Posting Yak Master
107 Posts |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-06-28 : 16:04:03
|
| Also [url]http://www.sqlteam.com/FilterTopics.asp?TopicID=118[/url]However my advice is to try and use CONTAINSTABLE where ever possible as the number one thing you can do to improve FTS queries is to limit the number of rows returned from the search service by using the top_n_by_rank qualifier of the CONTAINSTABLE statement.CheersJasper Smith |
 |
|
|
Jason_D
Starting Member
11 Posts |
Posted - 2002-06-28 : 16:40:50
|
| Hello again,I just looked up some of the references that was suggested and attempted to create a stored procedure with the "CONTAINSTABLE" function. Perhaps it's due to the fact that it's Friday with a long-weekend just around the corner but I'm not exactly sure how this is implemented - does anyone have an example of some coding using containstable?Jason |
|
|
|
|
|
|
CONTAINS or CONTAINSTABLE