• San-847017 (10/28/2009)


    I always increment identity column with default value.

    I used a seed = 1 and an increment of 5 and in another table seed = 2 and an increment of 5. So table A always has last digit = 1 or 6 and table B 2 and 7.

    When I reference in table C the two table above, I know thanks to the last digit which table is linked.