Images

I want to create a catalogue such thing with stores items in a shop, some with pictures. How do I store images in sql server 2000?
Thank YouPainfully...just store the path to the image...

Look up READTEXT, WRITETEXT in bol if your still interested...|||sort the threads on this forum .. its the tenth largest thread..
but please read it completely to get the idea to store images in SQL server|||how do you sort the threads??|||Click on the word reply...

http://www.dbforums.com/t203835.html|||are u sure u gav me the correct link...|||Originally posted by asbirpam
I want to create a catalogue such thing with stores items in a shop, some with pictures. How do I store images in sql server 2000?

Thank You

You can create a field in your table with the type of image. you can then save the image in the table.|||Check the thread http://www.dbforums.com/t203835.html referred by Brett which is updated.|||http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx is a really comprehensive article on that topic

Image in SQL2000

Hello!
What function in SQL SERVER 2000 to test an image field if empty or not? Tried NoT NULL but no success.
I want to return only items with pictures...
THanksDid you try DATALENGTH function?sql