Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
The exact phrase needs to be found
Message
 
 
À
17/12/2010 15:17:06
Information générale
Forum:
Level Extreme
Catégorie:
Autre
Divers
Thread ID:
01385793
Message ID:
01493158
Vues:
71
>>If you get the dataset, can you apply the extra condition in .NET side? Although you can also do it in SQL.
>>
>>And may be you can apply LINQ on the result set.
>
>This was my main concern. This full text syntax is not a regular SQL syntax. So, it would have to be processed in a second level. But, I am not sure if this could work. Because, the omitted word can be everywhere and might not be found as is in the first result.

I don't see the problem. You can put your original query into temp table.
Say,
select *  into #Result from Threads where contains(Threads.Notes,"my current phrase")

if @ExactPhrase
   select * from #Result where Notes like '%' + 'My current phrase' + '%'
else
  select * from #Result
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform