I always seem to be looking this up.  So here it is:

USE DatabaseName
GO

ALTER TABLE TableName
ADD CONSTRAINT ConstraintName
UNIQUE NONCLUSTERED (ColumnName)
GO