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 |
|
alexellice
Starting Member
13 Posts |
 Posted - 2011-11-20 : 11:05:57
|
| Hello again,I have use for some assistance setting a database which will hold URLs to images (saved on the server). I'm expecting there to be in excess of 15,000 entries.Each row will include a dateUploaded, imageUrl, ImageThbUrl, imageDescr, dateImageTaken (year) and so on...Now to my question.. I had assumed i could use a "Full text sesarch" but this function is not supported by the webhotel (Surftown in Denmark). I understand that i could use "like" with wild cards but this would be extremely slow and not very precise (I think).So what could I use instead? I'm still relativly new to MSSQL <<<-------- imporatant piont. I can though manipulate the string before sending it with c#. I was thinking about removing the small words like "and", "to", "in", "the" etc... you get the idea....Any help would be much appreciated.Thanks in advance. |
|
|
|
|
|
setting up a search query