September 8, 2014 at 11:23 pm
hello all.
I have a image type column with zip format.when I retrive this column to disk,I have a zip file.but I need to extract this column to disk wit unzip format and .Tiff,How do I this?please guide me.I need to guide immediately.thanks
September 9, 2014 at 7:17 am
elham_azizi_62 (9/8/2014)
hello all.I have a image type column with zip format.when I retrive this column to disk,I have a zip file.but I need to extract this column to disk wit unzip format and .Tiff,How do I this?please guide me.I need to guide immediately.thanks
Remember that columns don't have a format, they have a datatype. In this case you are using the image datatype. You should consider changing this to varbinary(max) since the image datatype is deprecated.
Now what I assume is that you have a zip file stored in a column with a datatype of image? What have you tried? You have a two step process here. First is to materialize the zip file. Second is to extract the information from the archive. The unzip portion of this is where many people run into problems. A quick google search reveals several answers, the best of which is right here on SSC. https://www.google.com/?gws_rd=ssl#q=sql+server+unzip+file
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply