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 Cherry64,520 pts.
All Answer Wiki Contributors: Denny Cherry64,520 pts.
If you live outside the United States, by submitting your email address you consent to having your personal data transferred to and processed in the United States.
Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.