How would you do it with MS Sql Client Tools and a file you just happen to have avaialable?
Here are the basic steps for uploading a file and storing it in your database.
1. Create a page with a form that includes a file tag. This form will submit to an 'action.cfm' page. Note the name of the .cfm page is not important, 'action.cfm' is an example.
2. On your 'action.cfm' use CFFILE with action="upload" tag to save the file to your filesystem.
Please reply if you have more questions.
My understanding of the FileStream feature of SQL 2008 is that it allows a VARBINARY (aka BLOB) field's contents to be stored on the file system. This is intended to make storage of files within the database server more efficient. One *should* be able to treat this field like any other VARBINARY field from a SQL statement perspective.
Someone please correct me if this information is incorrect or incomplete. My experience with SQL 2008 is limited.