| Groups | Blog | Home |
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 Contains Predicate and Double Quotes Posted by swtwllm NO[at]SPAM alum.iup.edu at 2/20/2004 6:03:37 AM I have been searching for an escape character or a way of escaping
double quotes that are actually in a string that I am using in the
contains predicate.
Here is an example
select *
from table
where contains(field, '"he said "what is wrong", that is what he
said"')
I need the double qu...more >>
Searching accros multiple columns Posted by RoastedPigeon at 2/20/2004 3:06:08 AM Can someone please help me
I have one table which I need to search multiple columns on
The table looks similar to thi
id Category Descriptio
--------------------------------------------------------------------------
0 Gardening Equipment ...more >>
what is this error means Posted by Peruris at 2/18/2004 2:21:41 PM The crawl seed <MSSQL75://SQLServer/75d7831f> in project <SQLServer
SQL0000500005> cannot be accessed. Error: 800700e9 - No process is on the
other end of the pipe. .
The crawl for project <SQLServer SQL0000500005> could not be started,
because no crawl seeds could be accessed. Fix the errors...more >>
Imp Technology index engine. Posted by Geir Holme at 2/18/2004 11:31:52 AM Hi all.
Has anyone heard about this software for SQL databases. As I can see this is
what lots of my customers want and of cause I want faster searches. Is there
anything the SQL Server 2000 developers are missing og is there a catch
somewhare. Any comments out there?
http://www.imptechnology...more >>
Portuguese language support for full-text? Posted by Desconfiado at 2/18/2004 9:36:08 AM Hi,
Can anyone tell me if there is some package wich allows full-text search engine to support portuguese words and forms?
We portuguese have some special characters like 'ç' wich are can be used in a word but when searching the net we usually don't use the 'ç' but the 'c' so full-text engine ...more >>
SQLFTQRY out of control? Posted by tbellucco NO[at]SPAM yahoo.com at 2/18/2004 6:56:53 AM Today we discovered a file on the C:\ folder of our SQL server (SQL
2000) called SQLFTQRY.TXT that is over 2 GB and growing by the second.
Something seems to be running out of control, can anyone shed some
light on this? What writes that file, and why does it go to the C:\
folder? We have ple...more >>
Full Text Search Query Problem Posted by Kit at 2/17/2004 7:45:22 PM Dear All
I cannot receive result by writing a CONTAINS query.
My query is like contain("22", column).
For some normal words, the query is fine. But for some
value like "22", the query cannot find the result.
Please help ...
...more >>
Check a field for extended characters ?? Posted by Joseph Eck at 2/17/2004 11:52:53 AM I am working on a project for my company. I am setting a flag when an error
occurs in the data. My "source" field can contain any characters in the
standard ASCII character set, but I want the flag to set when an extended
character (ASCII code 31 or less, or 128 and above) has been found. The
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Full-text indexing image datatypes (characters vs numbers) Posted by Jodi at 2/17/2004 11:46:07 AM I've created a full-text index successfully on an image datatype. The item count is the number of rows I expect and the unique key count is about at 1508. The unique key count is lower than I would expect for the html documents if they are being indexed correctly, but at least something is being i...more >>
restoring database Posted by gary at 2/16/2004 7:56:11 AM We are recovering to a test server using sql 2000 sp3. Even though both machines have the same service pack they both are showing a different version number. We want it to be showing 8.00.818 but instead is showing 8.00.760. It will not let us restore the database due to the different version number...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |