How to export image field to file?

Viewed 93234

I am using Microsoft SQL Server Management Studio to connect to a database. In it I've got a table, one column of which is an Image column containing file data. Another column is a string containing the file name.

Is there some way I can write some sql script that will allow me to select a record and write this data to a file? Or if this isn't possible, what's a simple way for achieving this?

I've seen this related question, but it doesn't seem quite the same: Save image column to file in sql-server 2000

4 Answers
Related