Monday, April 21, 2014

unique key based on 2 or more columns in SQl Server 2005 or later

CREATE UNIQUE NONCLUSTERED INDEX IX ON Tbl
(
        Col1  ,
        Col2 ,
 Col3
) WITH( IGNORE_DUP_KEY = OFF)

No comments:

Post a Comment