We help IT Professionals succeed at work.
Get Started

Storing an Image Into SQL Server 2008

Clif
Clif asked
on
207 Views
Last Modified: 2012-05-11
Yes, I'm aware of the arguments against storing an image in SQL Server, but it has to be done none the less.

So, everything I've run across seems to imply that you need VB pr C# (or some other dev platform).  Is it not possible to write a SQL query of sorts to copy an image from a BMP file into a BLOB field of SQL Server (and a corresponding query to take it from the field and create a file)?

If so, how?
Comment
Watch Question
Sr Database Engineer
Commented:
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE