Question

  Asked: Apr 30 2008   2:46 PM GMT
  Asked by: Naeem


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

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
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.
  • AddThis Social Bookmark Button

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.