Tag Archives: MS SQL

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>

Posted in Development | Tagged , | Leave a comment