Post reply

Select Image From Hard Disk

  • July 30, 2012 at 1:27 am

    #261733

    Hi,

    How can I write sql query like select c:\1.jpeg as 'Image' to capture picture from hard disk and represent that as a Column.

  • July 30, 2012 at 2:09 am

    #1519019

    Someone may correct me, but you cant unless its previously been inserted into a table as a filestream. It's not quite the same but as close as you'll get.

    You may be able to write a CLR function to do this for you if you knew the exact path. Also, you'll need an application to interpret the binary data if you'd expect to see an image.

  • July 31, 2012 at 12:44 am

    #1519535

    Hi,

    I have Routable IP Address,IIS and SQL server 2008 R2 with 1 table full of pictures.

    I need to Download these pictures from another computer in another city via FTP,

    How can I do it?

    Please Help me.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply