Home Forums SQL Server 2008 T-SQL (SS2K8) unique clustered index on 2 columns RE: unique clustered index on 2 columns

  • December 12, 2010 at 2:33 am

    #1261394

    ahmed7.bi (12/12/2010)

    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 ?????????

    Your clustered index is unique on column1 AND column2, not column1 OR column2: [1,1] is different to [2,1].

    [font="Arial"]Low-hanging fruit picker and defender of the moggies[/font]

    For better assistance in answering your questions, please read this[/url].

    Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

    Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]