How To Save File to varbinary(max) in SQL 2005

quartrj

New Member

Join Date: Jul 2008

Posts: 1
#1

How To Save File to varbinary(max) in SQL 2005

Jul 9 '08, 08:18 PM

For number of security reasons I can't use the Openrowset - Bulk option does any know of another way to load files into this data type.
Tags: None
ck9663

Recognized Expert Specialist

Join Date: Jun 2007

Posts: 2878
#2

Jul 9 '08, 11:15 PM

Can you use BULK INSERT?

Use Bulk Insert and store it in a table. Manipulate that table to store to a varbinary(max).

-- CK
Comment

Comment