The single easiest way to prevent duplicate data is to create a unique index on the column that you don't wish to duplicate data in. Whenever an insert occurs which includes data in the column with a unique key assigned, and the data is determined to be duplicate, the insert will fail.
|