image data type  
Author Message
shadowHead





PostPosted: Top

SQL Server Developer >> image data type

I need to store some images (employee mug shots) in a SQL 2000 table. Given
the table...

CREATE TABLE [pictures] (
[empno] [char] (9) NOT NULL,
[pic] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

and I have images such as "\\serverHR\emps\111223333.jpg" ...

can someone give me some example code that shows me how to store and
retrieve these images in the table above. I have been through the microsoft
help file and docs and am more confused than when I started.

Thanks

Charlie

SQL Server173