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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-07-06 : 11:53:43
|
| karen tan writes "Hi all,I have a table in MS Access DB which the table called Articles_Image Table . These are the followinf fields in Article_Image TableArticle_Image-------------------JPGname (PK) | Jpgdoc | CatDescNo | CategorySlnoI have import the Access database to SQL Server, i would like to know if SQL Server can able to provide either DTS services or using stored procedures to convert all those images stored as binary (BLOB) stored in Article_Image Table in SQL Server to a JPG image and stored in my folder example c:\imagesEach image file name is derived from the JPGname data. All the images are originally derive from JPG file.The reason is i need to retrieve all those images stored in the database to a real picture file for editing purpose." |
|
|
|
|
|
Hi i would like to know how to convert all blob ( binary ) to a image file & store into a directory