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 |
|
gowrisankar
Starting Member
1 Post |
 Posted - 2005-11-17 : 00:57:11
|
| Hi, I stored my html file in the database as blob. I want to do search on the file content. Can anybody help me in solving the problem?Thanks,sankar |
|
|
shallu1_gupta
Constraint Violating Yak Guru
394 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-11-17 : 01:20:31
|
| I think it is easy to store only the path of the file than file itself so that you will be easily interact with the file using File system object in your presentation layerMadhivananFailing to plan is Planning to fail |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-17 : 01:37:27
|
| "http://sleeksoft.co.uk/public/techblog/articles/20051117_1.html"TEXT or IMAGE?For TEXT you can do SELECT * FROM myTable WHERE MyText LIKE '%keyword%'Or you could use the Full Text tools in SQL ServerKristen |
|
|
|
|
|
|
Searching a file stored as blob