It is best to store pictures(.jpg, .gif) in a folder on the sql server, and have a column in the appopriate table for PictureFileName varchar(50).

While binary objects can be stored in the database, it is not very efficient, and cannot be manipulated with regular SQL statements.