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 |
|
vikrammullick
Starting Member
1 Post |
 Posted - 2005-11-11 : 05:15:09
|
| Hi , I want to store large files in a table.I am using SQLserver 2000and working on vb.net . Should i pass file contents as input variables to the stored procedure or my stored procedure should read the file content itself before inserting the data inside the table. Files are both text file as well as XML. Let me know which approach is more feasible and how do it.Later i also need to read contents of the file from the table.Regards, Vikram |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-11-11 : 09:11:30
|
storing large files is better in the file system server and saving only the path in the sql server.if you must store files in your table use image datatype.Go with the flow & have fun! Else fight the flow  |
 |
|
|
|
|
|
Storing Large files in a table