|
|
Posted by Erland Sommarskog on 09/13/07 22:09
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
Navigation:
[Reply to this message]
|