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 - 2004-06-17 : 15:04:36
|
| Param writes "Hi, I am working on an application which has Lotus Notes as frontend and SQL Server as backend. In one of the forms, there is a ifeld where users can attach documents. Can I save these documents to SQL Server. If yes, then can you let me know what should be the datatype of the column where I am storing this attachment. Also, what can be the max size of the attachment." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-17 : 15:15:39
|
| Yes you can save documents to SQL Server in an image column, but it is not recommended that you do this. You should store the file on disk and the path and file name in SQL Server.Tara |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-06-17 : 15:40:18
|
| datatype of image...and don't do it...It's not like a simple select to get the data out...Brett8-) |
|
|
|
|
|
|
Saving attachments to SQL Server