Enforce a unique constraint on a table with duplicate values

Question

I have a table with duplicate values in a column. I want to make the column unique but sql wont do it until i remove the duplicate values

Kirtan Patel · Answer

Friend Here Microsoft's Article About Removing Duplicate to Apply Constaints http://support.microsoft.com/kb/139444 and check  Do you like this answer  if it helps you :)

patrick · Answer

Yeah thats not a problem but is there a fast way to remove them?

Kirtan Patel · Answer

Friend You have to remove Duplicate Values or Make Them NULL . because its totally against the Rules Of RDBMS :) if my answer helped you check  do you like this answer