MS SQL Server 2005, write varbinary to file system

问题:

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.

回答1:

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