Storing Files in SQL SERVER

Posted by Abhisek under Sql Server on 4/4/2010 | Views : 2859 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi all,

I am working on a web application and want to store files(.doc, .docx,.pdf,.xls.etc) in the database. I am using SQL SERVER 2005 Express. I also want to retrieve the files from the database. Please tell how to store, retrieve/ download the files to/from the database. Please give me the complete procedure.

Abhisek Panda

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Abhijit Jana on: 4/4/2010 [Member] [MVP] Bronze

0	Abhisek, Insted of storing files on SQL Server, store the file path in Database and store the file in physical drive. While retreiving, based on the file path from of SQL Server, retreive the file from Physical location. Thanks ! Abhijit Cheers ! Abhijit Abhisek, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts