How can you store pictures on SQL Database?

In short, the SQL database column has to be defined as either an image column or a binary column (SQL2k) In earlier versions, 6.5 & 7, they should have been defined as a BLOB (Binary Large Object). A more precise answer can be given if you supply additional information such as DB version, programming langauge used.

**

As explained here you can store images within SQL server however I would not recommend this.

In doing so you will bloat the database dramatically, and the reconstitution of the images when recalled from the database is a big performance hit.

I would recommend storing the images within the file system (saved to your hard drive as normal) and linking the images to a database record by defining a column that hold the path and file name to the image.

In doing so your database overhead is simply that field and not the entire image.