Home > IT Answers > Database > Storing BLOB to file through SQL Server 2005
Naeem
5 pts.
 Storing BLOB to file through SQL Server 2005
BLOB, Database, SQL Server 2005
I want to know how to Export BLOB data to a JPG File at the SQL Server end ... NOT USING C# or VB

Software/Hardware used:
ASKED: April 30, 2008  2:46 PM
UPDATED: May 2, 2008  2:07 AM
RELATED QUESTIONS
Answer Wiki:
SQL Server will only give you the raw binary data. In theory you can take this data, and save it to a file with the JPG extension and it should be a valid JPG. Using a C#.NET or VB.NET application will be your best bet.
Last Wiki Answer Submitted:  May 2, 2008  2:06 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,520 pts.