Have Geek Brain

MS SQL Server 2005, write varbinary to file system

Using just a SQL query, is it possible to write the contents of a varbinary cell to the file system? I have a column that stores pdfs and for some quick testing I would like to write the pdfs to the filesystem.

Thanks for any help.

0


a source to share


1 answer


A similar question is here.

How do I dump all our images from a VARBINARY (MAX) field in SQL Server 2008 to the file system?



You need to iterate through each line and do a BCP (BulkCopy) dump of each varbinary field on the filesystem

0


a source






More articles:


All Articles