multiple compare

Hi,

I need to check a set of links against a large database that I have
created. As the links get added I check one by one that they don't get
added twice. I was wondering if it is possible to pass the entire SET
of links to be checked all at once instead of one by one. I am hoping
this will make my application run fast.

Thanks

Carl

carlbernardi@gmail.com wrote:
> Hi,
>
> I need to check a set of links against a large database that I have
> created. As the links get added I check one by one that they don't get
> added twice. I was wondering if it is possible to pass the entire SET
> of links to be checked all at once instead of one by one. I am hoping
> this will make my application run fast.
>
> Thanks
>
> Carl
>

Carl,

You can check them all at once - but I agree with Gordon. A Unique
Index on the column will ensure you have no duplicates.

That's part of its purpose.


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================