How to load jpeg file in SqL2000 and how to retrieve from SQL2000.

[parameswar]

Hi friends
Now I am working in SQL2000 as back end .I want to load jpeg file in database and retrieve from database. Please guide me.

[Deven123]

You can use this:

CREATE TABLE Images ([stream] [image] NULL)
insert into Images ([stream]) values (@image)

Hope this helps!!
Deven.