Code:
create table mytable
(
recordId int identity(1,1) primary key,
col2 int,
col3 int,
col4 int
)
basically i created the primary key recordID which will be unique in value. now how will i be able to set col2 and col3 have unique values too.