Force a column to have unique values in MSSQL.

ALTER TABLE dbo.MyTable
ADD CONSTRAINT UQ_MyTable_MyColumn UNIQUE (MyColumn);