CODEWITHSUNDEEP
sqlsql-serverwindowsimagesql-server-2008
Funereal
Funereal

Reputation: 673

Export Images stored in DB as hex files in folder

I got a table with 60000 images as Hex like : 

0xFFD8FFE000104A4649460001010100480...

How can I export all of them as real image in a folder? It is possible to do with a query?

Upvotes: 1

Views: 1572

Answers (1)

M84
M84

Reputation: 745

You can use BCP:

The bulk copy program utility (bcp) bulk copies data between an instance of MicrosoftSQL Server and a data file in a user-specified format. The bcp utility can be used to import large numbers of new rows into SQL Server tables or to export data out of tables into data files.

here you have definition: LINK1

and here you have an example: LINK2

hope this help!

Upvotes: 1

Related Questions