Posted by Zeljko Bilandzija on 09/15/07 20:57

Thanks to both of you on help

but i give you example what i'm interesing

i want to put some pictures on server or local disk, and i want make, for
example, column named "Pictures", and store in that column url or path on
local disk, to get that pictures when i refer to particular id in query on
web page. If I can do that in this way, which type of data to choose for
that column (how make that links or paths)

thanks


"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns99AB27A321B1Yazorman@127.0.0.1...
> Zeljko Bilandzija (zac9393@email.t-com.hr) writes:
>> 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?
>>
>> could someone explain me that process of putting at least one picture in
>> database, I'm using Microsoft SQL Server 2005
>
> The normal way of adding pictures, or any other data for that matter, is
> through an application.
>
> But you could use the BULK provider with OPENROWSET. Look at OPENROWSET
> in Books Online, and particularly at example D.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]