Save an blob via TSQL to Harddisk

• slzbi

  Mr or Mrs. 500

  Points: 535

  More actions

  April 18, 2008 at 12:01 pm

  #380067

  Hi Folks,

  i use the table Person.address from adventureworks.

  i add a column "Datei" with the datatype varbinary(max).

  Now i add a file like this:

  Update Person.Address

  set datei = (Select * from Openrowset( Bulk 'C:\Test.doc', Single_Blob) as x)

  where addressid = 2

  My question is:

  How can I receive the file from database to save it to localdisk; so that i have the file test.doc...

  Something like select datei from person.address where addressid=1...

  regards

  martin

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  April 20, 2008 at 8:57 pm

  #804741

  Could you use xp_cmdshell command to copy the file directly to your local machine?

• sqltung

  Hall of Fame

  Points: 3962

  More actions

  April 21, 2008 at 1:39 pm

  #805176

  slzbi (4/18/2008)

  ---

  Hi Folks,

  i use the table Person.address from adventureworks.

  i add a column "Datei" with the datatype varbinary(max).

  Now i add a file like this:

  Update Person.Address

  set datei = (Select * from Openrowset( Bulk 'C:\Test.doc', Single_Blob) as x)

  where addressid = 2

  My question is:

  How can I receive the file from database to save it to localdisk; so that i have the file test.doc...

  Something like select datei from person.address where addressid=1...

  regards

  martin

  Martin,

  This post is a duplicate of this one, which has an answer:

  http://www.sqlservercentral.com/Forums/Topic487470-338-1.aspx