what datatype must i use to store a file in microsoft sql server 2000?

Question

in microsoft access you could have stored any file type (e.g. *.bmp, or .avi) in a table using the OLE datatype. what data type must i use to do the same thing in microsoft sql server 2000 (MSDE)?

Answer 1

varbinary - but you shouldn't store files in a database - put them in a directory structure and store the path to the file.


Reply:
You mean like the load it puts on the database and how it can make things far more complicated to store and retrieve?

Answer 2

you shouldn't tell people not to store files in a db unless you are able give some valid reasons.