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 |
|
shapper
Constraint Violating Yak Guru
450 Posts |
 Posted - 2007-02-14 : 08:50:03
|
| Hello,I am working on a ASP.NET 2.0 project with an SQL 2005 database.I created a documents table with various columns including:DocumentId and DocumentUrlMy documents will always be PDF's of SWF's (Flash Paper Files)I will need to display this files in my web pages.My question is: Should I save the DocumentUrl in the database or should I save the file itself in the database?And how can I save files in an SQL 2005 database?Thanks,Miguel |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-14 : 13:35:10
|
| You should not save files to the database. Just store the URL in there, then store the file on the web server's file system.Tara Kizer |
 |
|
|
shapper
Constraint Violating Yak Guru
450 Posts |
Posted - 2007-02-14 : 14:02:49
|
| Tara, thanks for the advice.Miguel |
|
|
|
|
|
|
Save File in SQL 2005 Database