Tuesday, May 5, 2009

How to prevent duplication record?

You can use either of the following Approach:

1. Basically Creating a Unique Constraint suffice.
2. Creating Unique index (Unique Constraint + Index) would help you in case of frequent querying based upon that column.
3. Creating an Identity column to avoid duplication.

No comments: