Hi David_7,
Personally, I will suggest you to think about whether the files need to be stored in SQL server. How about just store the path of it?
If the file is large than 1M, and frenguently need to be read and written, it seems that store the path instead of file will be suitable. Here is an article to talk about this issue, and you can read it:
To BLOB or Not To BLOB: Large Object Storage in a Database or a Filesystem: http://research.microsoft.com/apps/pubs/default.aspx?id=64525
If you insist to add the file into the database, please refer to this article :
Uploading and downloading files to/from a SQL Server database: http://www.codeproject.com/Articles/225446/Uploading-and-downloading-files-to-from-a-SQL-Serv
We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.
No comments:
Post a Comment