Storing BLOB to file through SQL Server 2005
SQL Server 2005, BLOB, Database
I want to know how to Export BLOB data to a JPG File at the SQL Server end ... NOT USING C# or VB Question
SQL Server 2005, BLOB, Database
I want to know how to Export BLOB data to a JPG File at the SQL Server end ... NOT USING C# or VB 
Subscribe to Alerts! Get questions and answers delivered to your Inbox.
Answer Wiki (Improve, edit or add to this answer)
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
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.
Browse more Questions and Answers on SQL Server and Database.
Looking for relevant SQL Server Whitepapers? Visit the SearchSQLServer.com Research Library.
Discuss This Answer
You must be logged-in to discuss a question. Log-in/Register
Mrdenny | May 2 2008 2:07AM GMT
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.
