How do dowload file (saved as Image datatype) and save on disk?

• akhandels

  Right there with Babe

  Points: 731

  More actions

  January 21, 2011 at 11:31 am

  #245725

  Hi All,

  I have a table with approx 50,000 rows which stores files (.xls, .pdf, etc) as image datatype. I need to download all these files on disk. Is there a way to download these files only using T-SQL code?

  If not, what is the best way of achieving this ?

  Any help would be greatly appreciated.

  Thanks.

• Orlando Colamatteo

  SSC Guru

  Points: 182293

  More actions

  January 21, 2011 at 1:03 pm

  #1276753

  I would look into using the SQLCLR.

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato