You can insert data using a standard insert statement if you’d like. Most people will write a stored procedure which accepts the blob data as an input parameter and then the stored procedure will do the actual insert. You can then call the procedure from your calling application in a parameterized mode so that you don’t have to write the actuall execute command.
Your stored procedure would look something like this.
<pre>CREATE PROCEDURE usp_InsertWorkDoc
INSERT INTO FileTable
You will want to put some data checking to make sure that the file doesn’t already exist. You’ll also notice that I used the varbinary(max) data type. Word Docs are binary are as such need to be stored in a binary data type.