sql server programming: Avoiding Duplicate Text Data -- sql server programming

Avoiding Duplicate Text Data

Steve Harp
12/20/2006 10:43:25 PM

sql server programming:

Hi All,

I have a table that uses a text column to store lengthy (you guessed
it) text data. I need to write a store procedure that checks the
table prior to an insert/update to make sure the data isn't being
duplicated.

How can this be done with a stored proc?

Thanks,

Re: Avoiding Duplicate Text Data

niklas.arbin NO[at]SPAM nordicstation.com
12/20/2006 11:53:32 PM

I guess the fastest way would be to hash the text and compare the
values instead of comparing char vs. char.

/Niklas

Steve Harp skrev:

[quoted text, click to view]

Re: Avoiding Duplicate Text Data

Steve Harp
12/21/2006 9:48:18 PM

Can you point me to some information on how to do this? I found
CHECKSUM() to build a hash index but the help file says it won't work
with text columns.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server programming group.