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 |
|
sapator
Constraint Violating Yak Guru
462 Posts |
 Posted - 2007-11-05 : 03:58:25
|
| Hello. Can you tell me how can i upload a file to an SQL column?What must i do? Must i create a stored procedure???Thanks. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-11-05 : 04:47:02
|
http://weblogs.sqlteam.com/peterl/archive/2007/09/26/Insert-binary-data-like-images-into-SQL-Server-without-front-end.aspx
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-11-05 : 05:19:06
|
| Also, how about storing files in the physical directory of the server and store path in the column?MadhivananFailing to plan is Planning to fail |
|
|
|
sapator
Constraint Violating Yak Guru
462 Posts |
Posted - 2007-11-05 : 05:28:48
|
quote:
Also, how about storing files in the physical directory of the server and store path in the column?
Yes i thought of that. But what is better?To have the file in SQL or to have a reference to the file?Can SQL sustain a large amount of files?Thanks. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-11-05 : 05:33:10
|
| http://databases.aspfaq.com/database/should-i-store-images-in-the-database-or-the-filesystem.htmlMadhivananFailing to plan is Planning to fail |
|
|
|
sapator
Constraint Violating Yak Guru
462 Posts |
Posted - 2007-11-05 : 05:55:15
|
| ok thanks. |
|
|
|
|
|
|
Uploadinf files to SQL