Loading BLOB's to Database

I have the file with binary data on my hard disk.

Also I have the table in the database with image field.

I want to load binary data from file to this field. Does any body know how can i do it?

I want to do it using only T-SQL, without any С# (etc.) coding - only sql script is properly.

[312 byte] By [VladimirSapronov] at [2007-12-23]
# 1

there is no available sql feature to interact directly with the binary files.

you have to use stream read/write from dot net.

joeydj at 2007-8-31 > top of Msdn Tech,SQL Server,Transact-SQL...

SQL Server

Site Classified