Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Article Discussion
 Full text search-query
 Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

purisqlserver
Yak Posting Veteran

India
73 Posts

Posted - 09/24/2001 :  11:21:02  Show Profile
Sir,
I am trying query on table 'detail', which is full text indexed. while searching for a single character it gives error!!!.

Select * from Detail where contains(*,'"a"')

Error Message from sqlserver:

The query contained only ignored words.[red]


II) while searching for word like "networking
products", does it search out individual
words(networking or products), if so how can it be made as one word
for search using contains or some other function(freetext)?????
Thank you.

skak
Starting Member

4 Posts

Posted - 12/26/2001 :  15:24:53  Show Profile
I have question about BULK INSERT:

I was testing the stored procedure you (SQLTEAM) created. When I was executing the stored procedure I was getting the following error ...

"Server: Msg 4860, Level 16, State 1, Line 1"
"Could not bulk insert. File 'D:\temp\txtfile1.txt' does not exist."
there under D:\TEMP and my userid has sysadmin role. Pls. help me out here.
The EXEC statement I was using was:
EXEC ps_StudentList_Import "D:\temp\txtfile1.txt",1,2

Can you pls. tell me what is problem here? I know that the file is

Thanks,
Sri
Go to Top of Page

skak
Starting Member

4 Posts

Posted - 12/26/2001 :  15:25:04  Show Profile
I have question about BULK INSERT:

I was testing the stored procedure you (SQLTEAM) created. When I was executing the stored procedure I was getting the following error ...

"Server: Msg 4860, Level 16, State 1, Line 1"
"Could not bulk insert. File 'D:\temp\txtfile1.txt' does not exist."
there under D:\TEMP and my userid has sysadmin role. Pls. help me out here.
The EXEC statement I was using was:
EXEC ps_StudentList_Import "D:\temp\txtfile1.txt",1,2

Can you pls. tell me what is problem here? I know that the file is

Thanks,
Sri
Go to Top of Page

skak
Starting Member

4 Posts

Posted - 12/26/2001 :  15:25:13  Show Profile
I have question about BULK INSERT:

I was testing the stored procedure you (SQLTEAM) created. When I was executing the stored procedure I was getting the following error ...

"Server: Msg 4860, Level 16, State 1, Line 1"
"Could not bulk insert. File 'D:\temp\txtfile1.txt' does not exist."
there under D:\TEMP and my userid has sysadmin role. Pls. help me out here.
The EXEC statement I was using was:
EXEC ps_StudentList_Import "D:\temp\txtfile1.txt",1,2

Can you pls. tell me what is problem here? I know that the file is

Thanks,
Sri
Go to Top of Page

AjarnMark
SQL Slashing Gunting Master

USA
3246 Posts

Posted - 12/26/2001 :  15:38:36  Show Profile  Visit AjarnMark's Homepage
REDIRECT: http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=11674

Edited by - AjarnMark on 12/26/2001 15:41:16
Go to Top of Page

Nazim
A custom title

United Arab Emirates
1408 Posts

Posted - 12/27/2001 :  00:25:06  Show Profile
Contains does search in this way according to BOL
------------------------

Specifies a match of words or phrases beginning with the specified text. Enclose a prefix term in double quotation marks (““) and an asterisk (*) before the ending quotation mark. All text starting with the simple term specified before the asterisk is matched. The asterisk matches zero, one or more characters (of the root word or words in the word or phrase). When <prefix_term> is a phrase, each word contained in the phrase is considered to be a separate prefix. Therefore, a query specifying a prefix term of “local wine *” matches any rows with the text of “local winery”, “locally wined and dined”, and so on.

------------

if you want to search the whole word . isnt it simpler using like

something like this

select * from table where column contains 'Networking products'
you can also add wild card characters to it
like '%Nework Products%'



-------------------------
Graz's Baby is my Master:)
Go to Top of Page
  Previous Topic Topic Next Topic  
 Topic Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000