Storing files in SQL server

I was wondering could someone help me out. Im pretty new to SQL server and was wondering how do you create a table that could hold any type of file like word, spreadsheets literally anything. If this is even possible?

Or even just point me in the direction of the right answer id appreciate it. Thanks

The technical name for that is BLOB (Binary large object).

To create a table that stores this data, you will want to make the datatype (ntext, text or image). If you are not sure, use text. Although you CAN use this datatype in a table with lots of other normal columns, it is usually not recommended. I would recommend a seperate table with just a key field and the text field.

HTH
paul

I wouldn't recommend using BLOB's. They're slow and very fidely to code for. If you ever need to store files, I'd alwyas recommend the filesystem. Much more easier to manage. Just store the filename in the database.