developer
developer

Reputation: 1673

Convert exported image data

SQL server management studio does not allow to export image data type so image data type column was exported using the following query:

 SELECT 
 CONVERT(VARCHAR(MAX),CONVERT(VARBINARY(MAX),ImageDataTypeColumn),2) AS
ImageDataTypeColumn

I have the exported data as CSV file, how can I convert it back to the image data type and import it back to the table?

Upvotes: 0

Views: 47

Answers (0)

Related Questions