TSQL Insert file into database from script

Post date: Jan 13, 2010 10:31:47 AM

insert into t_file (c_name, c_binary)

select 'Test.txt', BulkColumn FROM OPENROWSET(

Bulk 'C:\test.txt', SINGLE_BLOB) AS IMAGE