How to save images to SQL Server?

Hi, All
I have a question?
I have scanned images (file format .tif) i need to store them in SQL Server.
And after all how fast is the  search for those images (search on 200
thousands images and up)

Thank you,

Are you going to put some other fields for searching purpose e.g. file
name, date created, creator etc?  Since they are image files, what kind
of search you want to put it on?

Mel

Hi,
Thank you for replay,
It will be one field "Ticket No", and i need to search by this field.
So it is possible, where i can get some more references? and SQL Server 2005
will be the answer


"MSLam" wrote:

> Are you going to put some other fields for searching purpose e.g. file
> name, date created, creator etc?  Since they are image files, what kind
> of search you want to put it on?
>
> Mel
>
>

..... still don't qutie get your question.  I shall take it as follow:

You have a table that has at least two fields: Ticket No and Image.
The Ticket No will be using INT as the data type and the Image will be
using text/image data type.

You will be using Ticket No for users to search on OR
You will be using Image for users to search on

If ticket no will be the field users need to search on, it should not
take long to retrieve records (assuming the Ticket no here is data type
int).  You can put a normal index on the field to speed up the search
(either clustered or non-clustered depending your situation).

If image will be the field users need to search on (based on text value
in the image file), you use FULL-TEXT index for this purpose.

Check BOL for more information about indexing.

Hope I got your question right.

Mel

Thank you, Mel

I need perform search on "ticket No" field and if found ti retrive the image
.
Thanks again,

"MSLam" wrote:

> ..... still don't qutie get your question.  I shall take it as follow:
>
> You have a table that has at least two fields: Ticket No and Image.
> The Ticket No will be using INT as the data type and the Image will be
> using text/image data type.
>
> You will be using Ticket No for users to search on OR
> You will be using Image for users to search on
>
> If ticket no will be the field users need to search on, it should not
> take long to retrieve records (assuming the Ticket no here is data type
> int).  You can put a normal index on the field to speed up the search
> (either clustered or non-clustered depending your situation).
>
> If image will be the field users need to search on (based on text value
> in the image file), you use FULL-TEXT index for this purpose.
>
> Check BOL for more information about indexing.
>
> Hope I got your question right.
>
> Mel
>
>