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
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