I have a field of datatype INT declared as follows
[barCodeID] int IDENTITY(1, 1) NOT NULL
Each time I insert a new record into the table, barCodeID increments by 2, not by 1.
Why so and can I make it increment by 1?
I also tried
[barCodeID] int IDENTITY(0 , 1) NOT NULL
which produces exactly the same result, so what the first digit(seed) actually defines ?
as you can see I'm a complete newbie
View Complete Post