Sqlserver self growth fields increase the number is not valid.

ALTER TABLE tablename ADD FRowID int NOT NULL IDENTITY (1, 1);

The result is like this.

Started by Samson at February 10, 2016 - 12:39 AM

Set the initial starting seed

Posted by Alexander at February 17, 2016 - 1:28 AM

May not be the result, have repeated.

Posted by Levi at March 04, 2016 - 1:52 AM

IDENTITY (1, 1)Is the initial value of 1, increasing amount of 1.
Is this table has a large number of records?

Posted by Mike at March 12, 2016 - 1:54 AM

You this is too strange, since it is a new field to add, how have so many -201326566.

Posted by Cloris at December 24, 2016 - 10:42 PM

The insert or update do not deal with this field
If you fill a value is wrong

Posted by Adair at January 02, 2017 - 10:43 PM

You had a lot of data, and then add the fields from the increase.

Posted by Harvey at January 06, 2017 - 11:41 PM

Type length .

Posted by Lauren at January 14, 2017 - 11:44 PM

Overflow~~~~

Posted by Hunter at January 14, 2017 - 11:49 PM