• http://msdn.microsoft.com/en-us/library/ms186775.aspx

    IDENTITY(1,1), means start at 1 (1,x) and add 1 (x,1) every time a new row is inserted

    1

    2

    3

    4

    5

    6

    7

    IDENTITY(100,200) means start at 100 (100,x) and add 200 (x,200) every time a new row is inserted

    100

    300

    500

    700

    900

    1100

    1300