• as mentioned above i have inserted below records

    insert into test4 values (1,1,'asd')

    go

    insert into test4 values (2,1,'asd')

    the command executed successfully

    my query is that as i have included first two columns in the unique clustered index then how can it accepts duplicates in column 2 ..the what is the use of defining column 2 in unique clustered index ?????????