RE: Extract pdf file from a sql db

SSC Guru

Points: 323504

February 23, 2015 at 12:31 pm

certainly possible, but you probably need a bit more information.

this example here, you could adapt, and is assuming there is an identity/primary key to the table.

http://stackoverflow.com/questions/26541068/how-can-i-bcp-queryout-with-filename-from-table

If you can install CLR on a database, i personally use a version of Elliot Witlows Common Language Runtime example he published here:

http://nclsqlclrfile.codeplex.com/

--MSPSaveFileImage

-- Parameters: @FilePath,@FileName,@FileBytes

-- purpose: given an varbinary image column in a table, write that image to disk

-- usage:

--assumes table and the file from the example above for dbo.MFGetFileImage exists already.

declare @myfile varbinary(max)

SELECT @myfile = rawimage FROM myImages WHERE id = 1

EXEC dbo.MSPSaveFileImage 'C:\Data','spinning.gif',@myfile

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!