Split Column

[Reez]

Hey

If I have one column, and I want to split the numbers into 2 columns such that these 2 columns can't have the same values at the same row.

 

[Rabbie]

You will need to give us more information about your data so we can help you

 

[WayPay]

You will have to create 1 unique index on both columns:

CREATE [ UNIQUE ] INDEX [I]index[/I]
    ON [I]table[/I]  ([I]field[/I] [ASC|DESC][, [I]field[/I] [ASC|DESC], ...])
    [WITH { PRIMARY  | DISALLOW NULL | IGNORE NULL }]