Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
purisqlserver
Yak Posting Veteran
73 Posts |
 Posted - 2001-09-24 : 11:21:02
|
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 "networkingproducts", does it search out individualwords(networking or products), if so how can it be made as one wordfor search using contains or some other function(freetext)?????Thank you. |
|
|
skak
Starting Member
4 Posts |
Posted - 2001-12-26 : 15:24:53
|
| 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,2Can you pls. tell me what is problem here? I know that the file is Thanks,Sri |
 |
|
|
skak
Starting Member
4 Posts |
Posted - 2001-12-26 : 15:25:04
|
| 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,2Can you pls. tell me what is problem here? I know that the file is Thanks,Sri |
|
|
|
skak
Starting Member
4 Posts |
Posted - 2001-12-26 : 15:25:13
|
| 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,2Can you pls. tell me what is problem here? I know that the file is Thanks,Sri |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2001-12-26 : 15:38:36
|
| REDIRECT: [url]http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=11674[/url]Edited by - AjarnMark on 12/26/2001 15:41:16 |
|
|
|
Nazim
A custom title
1408 Posts |
Posted - 2001-12-27 : 00:25:06
|
| 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 likesomething like this select * from table where column contains 'Networking products'you can also add wild card characters to itlike '%Nework Products%'-------------------------Graz's Baby is my Master:) |
|
|
|
|
|
|
|
|
Full text search-query