|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
|
Hi
Since I have never had a good search methods I am looking for some reading material/source code to know what is achievable relatively easily Thank you for your suggestions, Samuel On Thu, 29 Jun 2006 23:42:05 +0100, "Samuel Shulman"
<samuel.shul***@ntlworld.com> wrote: >Hi I start by checking my pockets. Then I check the pockets of whatever> >Since I have never had a good search methods I am looking for some reading >material/source code to know what is achievable relatively easily > >Thank you for your suggestions, >Samuel I had on yesterday. Then I look in the seat cushions, maybe check the car... try to remember where I had it last, try to think if anyone else might have taken it. Sometimes I ask my wife to help look. If I do find it, it always ends up being in the last place I look. YMMV. Roy Harvey Beacon Falls, CT So, search related to searching on the internet, searching the file system,
searching through a database, searching a string... Could you, if it's not too much trouble, let us in on your intentions -it would be so much easier to help you if you would. -- Show quoteArnie Rowland, YACE* "To be successful, your heart must accompany your knowledge." *Yet Another Certification Exam "Samuel Shulman" <samuel.shul***@ntlworld.com> wrote in message news:%23z6%23$08mGHA.4760@TK2MSFTNGP05.phx.gbl... > Hi > > Since I have never had a good search methods I am looking for some reading > material/source code to know what is achievable relatively easily > > Thank you for your suggestions, > Samuel > > I meant SQL SERVER (which is why I put it in this question in this group)
I know of a number of search tips but I have never done any thing big and I am sure there are structured methods to search the database and there is no point for me to re-invent these It may be built in into sql SERVER and possibly there are other standard methods for one word or multi word search I am sure there some articles that would give a clue of what can be done thank you, Samuel Show quote "Arnie Rowland" <ar***@1568.com> wrote in message news:uMkaa$9mGHA.192@TK2MSFTNGP03.phx.gbl... > So, search related to searching on the internet, searching the file > system, searching through a database, searching a string... > > Could you, if it's not too much trouble, let us in on your intentions -it > would be so much easier to help you if you would. > > -- > Arnie Rowland, YACE* > "To be successful, your heart must accompany your knowledge." > > *Yet Another Certification Exam > > > "Samuel Shulman" <samuel.shul***@ntlworld.com> wrote in message > news:%23z6%23$08mGHA.4760@TK2MSFTNGP05.phx.gbl... >> Hi >> >> Since I have never had a good search methods I am looking for some >> reading >> material/source code to know what is achievable relatively easily >> >> Thank you for your suggestions, >> Samuel >> >> > > > It may be built in into sql SERVER and possibly there are other standard So you have a column containing free-form text and you want to search the > methods for one word or multi word search column for one or more words matching the specified criteria? In that case, see full-text catalogs in the Books Online. If you situation is different, it might help if you post a specific example to clarify your requirements. -- Show quoteHope this helps. Dan Guzman SQL Server MVP "Samuel Shulman" <samuel.shul***@ntlworld.com> wrote in message news:uBICVaDnGHA.4448@TK2MSFTNGP04.phx.gbl... >I meant SQL SERVER (which is why I put it in this question in this group) > I know of a number of search tips but I have never done any thing big and > I am sure there are structured methods to search the database and there is > no point for me to re-invent these > > It may be built in into sql SERVER and possibly there are other standard > methods for one word or multi word search > > I am sure there some articles that would give a clue of what can be done > thank you, > Samuel > > > "Arnie Rowland" <ar***@1568.com> wrote in message > news:uMkaa$9mGHA.192@TK2MSFTNGP03.phx.gbl... >> So, search related to searching on the internet, searching the file >> system, searching through a database, searching a string... >> >> Could you, if it's not too much trouble, let us in on your intentions -it >> would be so much easier to help you if you would. >> >> -- >> Arnie Rowland, YACE* >> "To be successful, your heart must accompany your knowledge." >> >> *Yet Another Certification Exam >> >> >> "Samuel Shulman" <samuel.shul***@ntlworld.com> wrote in message >> news:%23z6%23$08mGHA.4760@TK2MSFTNGP05.phx.gbl... >>> Hi >>> >>> Since I have never had a good search methods I am looking for some >>> reading >>> material/source code to know what is achievable relatively easily >>> >>> Thank you for your suggestions, >>> Samuel >>> >>> >> >> > > If you need to search char, varchar, text or image columns use SQL Full-text
search. If its a small table you can use a like. -- Show quoteHilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com "Samuel Shulman" <samuel.shul***@ntlworld.com> wrote in message news:uBICVaDnGHA.4448@TK2MSFTNGP04.phx.gbl... >I meant SQL SERVER (which is why I put it in this question in this group) > I know of a number of search tips but I have never done any thing big and > I am sure there are structured methods to search the database and there is > no point for me to re-invent these > > It may be built in into sql SERVER and possibly there are other standard > methods for one word or multi word search > > I am sure there some articles that would give a clue of what can be done > thank you, > Samuel > > > "Arnie Rowland" <ar***@1568.com> wrote in message > news:uMkaa$9mGHA.192@TK2MSFTNGP03.phx.gbl... >> So, search related to searching on the internet, searching the file >> system, searching through a database, searching a string... >> >> Could you, if it's not too much trouble, let us in on your intentions -it >> would be so much easier to help you if you would. >> >> -- >> Arnie Rowland, YACE* >> "To be successful, your heart must accompany your knowledge." >> >> *Yet Another Certification Exam >> >> >> "Samuel Shulman" <samuel.shul***@ntlworld.com> wrote in message >> news:%23z6%23$08mGHA.4760@TK2MSFTNGP05.phx.gbl... >>> Hi >>> >>> Since I have never had a good search methods I am looking for some >>> reading >>> material/source code to know what is achievable relatively easily >>> >>> Thank you for your suggestions, >>> Samuel >>> >>> >> >> > > On Thu, 29 Jun 2006 23:42:05 +0100, "Samuel Shulman"
<samuel.shul***@ntlworld.com> wrote: >Hi There is always The Art of Computer Programming Volume 3: Sorting and> >Since I have never had a good search methods I am looking for some reading >material/source code to know what is achievable relatively easily > >Thank you for your suggestions, >Samuel Searching by Donald Knuth. http://www.bookpool.com/sm/0201896850 Roy  |
|||||||||||||||||||||||
Other interesting topics