| 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 5 Storing word file in SQL Server 2000 and searching words using SQL Query Posted by Pranita at 11/21/2003 4:52:39 PM Hi John,
Thanx for the reply. But still I am not getting the output.
Table Name: test_a
Fields are:
ID Int 4 - Primary Key
Name nvarchar 100
Document Image 16 Null
Full Text Indexing is done on Name f...more >>
Storing word file in SQL Server 2000 and searching words using SQL Query Posted by Pranita at 11/21/2003 11:19:09 AM Hi All,
I am storing a word file in a blob field in SQL Server 2000. I want to
search the specific words in a row in the blob field, using SQL Query.
e.g. Table Name: test_a
Fields are:
ID Int 4 - Primary Key
Name nvarchar 100
Document Image 16 Null
Data in this table test_a:
...more >>
Contains not returning exact phrase Posted by Rogue Petunia at 11/21/2003 10:41:47 AM Hello,
The results look more like a FREETEXT than a CONTAINS search. I thought
CONTAINS would return results only with exact phrase - where the words are
in order and contiguous. This search returns results that don't even
contain both words. The only result I would have expected to see from ...more >>
should I use FREETEXT Posted by shank at 11/20/2003 7:05:21 PM I have 3 tables....
Main table is [Stock] which contains columns [ItemNo], [Description],
[Type], and other columns..
1st Related table is [Songs] which contains columns [ItemNo], [SongTitles],
[Singers], and other columns..
2nd Related table is [Equipment] which contains columns [ItemNo],
[Fe...more >>
Re: Some code to test stemmer output if you are interested Posted by John Kane at 11/20/2003 6:26:01 AM re-posting as I'm not sure if this got posted the first time around...
John
Tony,
If it still using the US_English version, perhaps it's because your server's
'default full-text language' is set to 1033 (US_English) as well? What does
the following SQL code return?
use master
go
sp_con...more >>
Storing word file in SQL Server 2000 and searching words using SQL Query Posted by Pranita at 11/19/2003 6:16:05 PM Hi All,
I am storing a word file in a blob field in SQL Server 2000. I want to
search the specific words in a row in the blob field, using SQL Query.
Please anyone suggest me the solution.
Pranita.
...more >>
how to set up Change Tracking Posted by Rogue Petunia at 11/18/2003 5:24:03 PM Hello,
I'm working on setting up full text search. What I want is to do background
updating with Change Tracking. I have a timestamp column on my table.
I have filled the index once like this:
exec sp_fulltext_table @tabname = 'Copy', @action = 'start_full'
How do I set it up to do backgr...more >>
Microsoft Search service won't start Posted by Bob Tee at 11/18/2003 2:35:22 PM On a new server after installing SQL 2k the Microsoft Search Service won't
start.
First error message: Timeout (30000 milliseconds) waiting for the Microsoft
Search service to connect.
Second error message: The Microsoft Search service failed to start due to
the following error:
The service di...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|
| home · blog · groups | Questions? Comments? Contact the dn |