I don’t think this can be done with SQL only. An application might be necessary.
Have a look at the following examples:
The easiest way is to write a client app to do it.
If you must do it with T/SQL you can use the BULK INSERT command with the RAW flag to load the data from the image file into a single row of a temp table. Then put the value into a variable with the data type of VARBINARY(MAX) and put that value into your table.
Your best bet is to use a client app to do it though.