Hellow!
What is the difference between FREETEXT and CONTAINS functions?
If i search word or phrase in text or ntext field,
what function use better?
thank you!
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20305389.html
Hi there,
I am working on a website that sells products from Spain. As such, many spellings are hard to muster for those English-Speaking amongst us and, indeed, the website is for the UK market...
http://www.experts-exchange.com/Database/MySQL/Q_22093381.html
Zones:
MySQL ServerDate Answered: 07/21/2007 Grade: A Views: 5
Hi all,
In my place of work we have a media archive of news and programs, its all text, i have implemented full text search on some tabels, my problem actually is when i am trying to search any ch...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20913502.html
Hi everyone,
I would have thought that if I had a column called product_desc and if one of the records contained the following for product_desc:
<h1>Ladder</h1><br>This is a ve...
http://www.experts-exchange.com/Database/Miscellaneous/Q_21055231.html
Zones:
DatabasesDate Answered: 08/27/2004 Grade: A Views: 0
I am using VS.NET 2005 and SQL Server 2005
I am getting an error running the following query.
SELECT [notes] FROM [Info] WHERE (CONTAINS([notes], @notes)) ORDER BY [info_date] DESC
The note...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21501493.html
Zones:
MS SQL ServerDate Answered: 07/22/2005 Grade: A Views: 184
I am using a server with the SQL locale set to the US, however the site is for an english audience.
I have a newsroom script that currently uses free text fields to allow the user to specify a d...
http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/Q_21658001.html
I have an existing stored procedue that I need to change to get a website search engine working better. The current sp searchs fine if you only feed it one word. Once you go beyond that you are b...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21658263.html
Hi,
Created a table that has 'Full-text' Indexing on column log_note. I've created the following two queries, the first works fine but the second only searches/returns data for the first entry ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22115114.html
Hi,
My dataset always retrieves up to 1000+ records which is overwhelming
How do i display only first 100 records and not show the rest.
I use Microsoft Indexing Server and ASP.NET code to d...
http://www.experts-exchange.com/Database/Miscellaneous/Q_22146431.html
Zones:
DatabasesDate Answered: 03/02/2007 Grade: A Views: 0
Hi
I have following where clause in a query, that I woul like to convert to a Freetext search
Where (products.article LIKE '%'+ @SearchString +'%' OR products.title LIKE '%'+ @SearchString +'...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21722260.html
