How to export image field to file?

Question

Hi,

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?

Thanks very much.

I've seen this related question, but it doesn't seem quite the same. http://stackoverflow.com/questions/1328914/save-image-column-to-file-in-sql-server-2000

Answer 1

http://www.simple-talk.com/sql/t-sql-programming/reading-and-writing-files-in-sql-server-using-t-sql/

go to this link this may be useful to you.