Posted by Greg D. Moore \(Strider\) on 09/13/07 13:30

"Zeljko Bilandzija" <zac9393@email.t-com.hr> wrote in message
news:fcb9oh$50d$1@ss408.t-com.hr...
> Hy, could someone help me in this:
>
> In design mode, i want to put pictures in database. I made column named
> pics, and its type as image. How can I put pictures or some address of
> these pictures in that column, or i maybe need to put pictures in Add_Data
> folder and make reference from there, or what I need to do?

Personally, I prefer to store files in the file system and links to them in
the DB.

On top of that I prefer to use two fields, one a directory and one the name
of the file itself.

Makes it a tad easier to do a mass update if I need to move the directory
(say to a different drive).


>
> could someone explain me that process of putting at least one picture in
> database, I'm using Microsoft SQL Server 2005
>
> thanks everyone
>



--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

[Back to original message]