Unique Key on 2 columns in SQL Server.

Hi friends,in this post i would like to explain how to create Unique Key on 2 columns in SQL Server.

For Example:

Here i am created Unique Key for 2 columns(Name,SurName) on College table.

CREATE TABLE [dbo].[College] ADD CONSTRAINT [UK_College] UNIQUE NONCLUSTERED
(
[Name] ,
[SurName]
)
WITH (PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]

Thank you...