0

Using just an sql query is it possible to write the contents of a varbinary cell to the file system? I have a column that stores pdf s as and for some quick testing I'd like to write out the pdfs to the filesystem.

Thanks for any help.

Andomar
  • 225,110
  • 44
  • 364
  • 390
bplus
  • 7,383
  • 15
  • 60
  • 84

1 Answers1

0

Similar Question Here.

How to dump all of our images from a VARBINARY(MAX) field in SQL Server 2008 to the filesystem?

You'll need to iterate through each row and perform a BCP (BulkCopy) Dump of each varbinary field to the filesystem

Community
  • 1
  • 1
Eoin Campbell
  • 42,194
  • 17
  • 98
  • 153