Very Computer

by **Liana Chi** » Tue, 04 Dec 2001 21:48:00

hi,
how can I intercept and trait one error for duplicated values in one unique
index?

thanks,
Liana

by **Stu** » Wed, 05 Dec 2001 01:54:03

You first need to identify duplicate rows. Assuming this
table:

CREATE TABLE MyTable
( MyKey int PRIMARY KEY,
SomeValue varchar(200) NOT NUL
)

Assume that you want to build a UNIQUE index on SomeValue,
but you get an error message indicating that one or more
values are not unique. You could identify those rows with
this query:

SELECT MyKey, SomeValue FROM MyTable WHERE SomeValue IN
(SELECT SomeValue, COUNT(*) FROM MyTable
GROUP BY MyKey
HAVING COUNT(*) > 1)

How you proceed from that point depends on what you need
to do -- delete the duplicate rows, change SomeValue to
make it unique, etc.

Stu Bloom, MCSD

Quote:>-----Original Message-----
>hi,
>how can I intercept and trait one error for duplicated

values in one unique

Quote:>index?

>thanks,
>Liana

>.

Very Computer

Index - error

Index - error

Index - error