Nils Gustav Stråbø (10/19/2012)
Aaaaarg!!! Got it wrong because of the unclustered index options.I know that SQL Server enforces unique constraints by creating unique indexs, but I wasn't sure if this was what the author meant.
A minor detail; You probably mean ROGUIDCOL, not ROWGUID.
declare @tabela table
(id int not null,
val1 varchar(20),
val2 varchar(20),
unique(val1,val2),
primary key nonclustered(id,val1)
)
Igor Micev,My blog: www.igormicev.com