Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Select Image From Hard Disk Expand / Collapse
Author
Message
Posted Monday, July 30, 2012 1:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 31, 2012 12:43 AM
Points: 2, Visits: 4
[color=#000000][/color]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.
Post #1337086
Posted Monday, July 30, 2012 2:09 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 7:33 AM
Points: 1,361, Visits: 15,264
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.

Post #1337097
Posted Tuesday, July 31, 2012 12:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 31, 2012 12:43 AM
Points: 2, Visits: 4
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.
Post #1337688
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse