Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
pushp82
Yak Posting Veteran
83 Posts |
Posted - 2012-10-10 : 01:30:59
|
Dear all,I have images in varbinary column and I need them in folder as .png. How to do this?I tried BCP but could not succeed.Please help! An immediate response would be applicable.is it possible?Thanks, |
|
chadmat
The Chadinator
1974 Posts |
Posted - 2012-10-10 : 02:07:38
|
Look into Filestream.-Chad |
|
|
pushp82
Yak Posting Veteran
83 Posts |
Posted - 2012-10-10 : 04:51:28
|
I did the job by BCP command: DECLARE @Command NVARCHAR(4000) SET @Command = 'bcp "SELECT PictureBinary FROM mcdonaldswosbkup.dbo.TABLE WHERE TABLEID = ' +convert(VARCHAR,82) + '" queryout "c:\Temp\Images\' + 'test.png' + '" -T -n -SSERVERNAME' PRINT @Command -- debugging EXEC xp_cmdshell @Command |
|
|
pushp82
Yak Posting Veteran
83 Posts |
Posted - 2012-10-10 : 05:21:05
|
I did the job by BCP but it is just creating an icon of no image any solution guys??? |
|
|
|
|
|