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
  • 232,371
  • 49
  • 380
  • 404
handles
  • 7,639
  • 17
  • 63
  • 85

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
  • 43,500
  • 17
  • 101
  • 157