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 |
|
ann06
Posting Yak Master
171 Posts |
 Posted - 2008-04-01 : 09:34:55
|
| Hi there,Am working on an archiving system that stores files/images in a column of type Binary. we want to change the front end of this archiving system it was done using asp.net we dont have access to the source codewhat is the way to retrieve the files from the binary columns?how they store or retrieve the files?Thanx best site for sql,,, |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2008-04-01 : 13:20:01
|
| Most people (i think) store files and images as files on a filesystem and just store references to the files in the database. That is my preference.>>what is the way to retrieve the files from the binary columns?your binary column would simply hold the content of the file and you SELECT the data as you do data from any database column. How you interperate the results is another story and depends on the nature of the data and the application performing the select. Sorry, I don't have any experience with that, but if you don't get any more responses you may want to post a more specific question in the ASP.Net forum.Be One with the OptimizerTG |
 |
|
|
|
|
|
Binary Data