file attachment field

[Michael57]

I'm creating a form in infopath that is hooked up to an sql table. I would like to have a field for an attachment in the table. What datatype is an attachment file.

 

[SQLDenis]

>> What datatype is an attachment file

are you storing the file in a table or are you just storing the filepath to the file?

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

 

[Michael57]

It could be an email,adobe file, word document or excel spread sheet.

Thanks

 

[Michael57]

Sorry I don't want to store the path I want to store the actual file

 

[ptheriault]

what version of SQL Server are you using?
If you are using SQL Server 2005 I would recomend using a VARCHAR(MAX). This datatype can hold up to 2 gb of data.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[SQLDenis]

Can't help you with that since I would never store such stuff in the DB
I always store the filepath to the file that way my backups are smaller and I can have the file on 8 different webservers instead of 8 webservers hitting the DB to return this file
and BLOBs are a pain in the neck to deal with since you can not use regular UPDATE statemensts but you have to use UPDATETEXT with TEXTPTR etc etc etc



Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/