Populate a Binary Database Field Using a Local File

You can run the following SQL statement to populate a binary database field using a local file.

UPDATE <table>
SET <field> = (SELECT BulkColumn from Openrowset( Bulk ‘<full file path accessible by the server>’, Single_Blob) as <field name>)
WHERE <where condition>

This entry was posted in Development and tagged , . Bookmark the permalink.

Leave a Reply