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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-02 : 09:08:31
|
| M.imran Butt writes " SQL server 7.0 and jdk1.3 database table : coloumns FileName , FileContents, FileSize Where FileContenets datatype may be Text or Image.My Question is : I want to save any kind of file say .... *.txt, *.doc, *.bmp *.avi, *.mpeg , *.java say .. To my data base in SQl server ....... What kind of Data type is required to save contents of File? How they can be inserted, updated, deleted, and selectd ofcourse? If any tutorial or site available plz. recommed. If any code available for insertion plz mail me. email : imran_cst@hotmail.com Thanks in advance." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-04-02 : 09:13:58
|
| This is described in the SQL Team FAQ, and it is NOT recommended to store documents or files in a SQL Server database. Leave the files on disk, and store links to them in your database. It is far more flexible and efficient. |
 |
|
|
|
|
|
Save any file to Sql server database